1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
insert into historique_precompte(
num_historique_precompte,
NUM_ADHERENT ,
NUM_AYANT_DROIT,
CODE_REGION_FISCALE,
CODE_PRECOMPTE_CSG,
BOOL_MAJORATION_FAMILIALE,
TYPE_ORIGINE,
BOOL_PRECOMPTE_COTMAL,
BOOL_RETENUE_SOURCE,
TAUX_COTISATION_EXPATRIE,
BOOL_VERSEMENT_RMI,
CODE_REGION_COURTIER,
dt_creation,
user_maj
) values (SELECT seq_historique_precompte.nextval as num_historique_precompte, mpp.NUM_ADHERENT , mpp.NUM_AYANT_DROIT, mpp.CODE_REGION_FISCALE ,
mpp.CODE_PRECOMPTE_CSG, BOOL_MAJORATION_ENFANT as BOOL_MAJORATION_FAMILIALE , mpp.TYPE_ORIGINE ,
mpp.BOOL_PRECOMPTE_COTMAL , mpp.BOOL_RETENUE_SOURCE, , mpp.TAUX_COTISATION_EXPATRIE ,
mpp.BOOL_VERSEMENT_RMI , mpp.CODE_REGION_COURTIER , sysdate , 'systeme'
FROM ECRITURE_PAIEMENT ep, MODALITE_PRESTATION_PERSONNE mpp, MODALITE_PRESTATION_REGIME mpr, dual
WHERE (mpp.num_adherent = ep.num_adherent
AND mpp.num_adherent = mpr.num_adherent
AND mpp.num_adherent is not null)
OR
(mpp.NUM_AYANT_DROIT = ep.NUM_AYANT_DROIT
AND mpp.NUM_AYANT_DROIT = mpr.NUM_AYANT_DROIT
AND mpp.NUM_AYANT_DROIT is not null )
AND ep.num_caisse = 2
AND mpp.code_region_fiscale IN ('FRANCE', 'DOM')) |
Partager