[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Incremental_Update IS
--
l_sql_stmt VARCHAR2(2000);
SELECT pgm.pgm_id pgm_id
FROM ben_pgm_f pgm
WHERE l_effective_date BETWEEN pgm.effective_start_date
AND pgm.effective_end_date
AND pgm.pgm_typ_cd IN ('CORE', 'FLEX', 'FPC', 'OTHER')
AND EXISTS (
SELECT 'x'
FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp
WHERE pet.pgm_id = pgm.pgm_id
AND pet.enrt_typ_cycl_cd = 'O'
AND l_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id)
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_CO_PGM_CT pgmd
WHERE pgmd.pgm_id = pgm.pgm_id);
SELECT ctp.ptip_id ptip_id, ctp.pl_typ_id pl_typ_id, ctp.pgm_id pgm_id,
ctp.ordr_num ptip_ordr_num
FROM ben_ptip_f ctp, ben_pl_typ_f ptp
WHERE ctp.pl_typ_id = ptp.pl_typ_id
AND l_effective_date BETWEEN ctp.effective_start_date
AND ctp.effective_end_date
AND l_effective_date BETWEEN ptp.effective_start_date
AND ptp.effective_end_date
AND ptp.opt_typ_cd <> 'SPDGACCT'
AND EXISTS (SELECT 'x'
FROM hri_cs_co_pgm_ct pgmd
WHERE pgmd.pgm_id = ctp.pgm_id)
AND NOT EXISTS (SELECT 'x'
FROM hri_cs_co_pgmh_ptip_ct ctpd
WHERE ctpd.ptip_id = ctp.ptip_id);
SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id, cpp.ordr_num plip_ordr_num
FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
WHERE cpp.pl_id = pln.pl_id
AND pln.pl_typ_id = ctpd.pl_typ_id
AND cpp.pgm_id = ctpd.pgm_id
AND pln.invk_flx_cr_pl_flag = 'N'
AND pln.imptd_incm_calc_cd IS NULL
AND l_effective_date BETWEEN cpp.effective_start_date
AND cpp.effective_end_date
AND l_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_CO_PGMH_PLIP_CT cppd
WHERE cppd.plip_id = cpp.plip_id);
SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id
FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
WHERE cpp.pl_id = pln.pl_id
AND pln.pl_typ_id = ctpd.pl_typ_id
AND cpp.pgm_id = ctpd.pgm_id
AND ( pln.enrt_pl_opt_flag = 'Y'
OR NOT EXISTS (
SELECT 'x'
FROM ben_oipl_f cop
WHERE cop.pl_id = pln.pl_id
AND l_effective_date BETWEEN cop.effective_start_date
AND cop.effective_end_date)
)
AND l_effective_date BETWEEN cpp.effective_start_date
AND cpp.effective_end_date
AND l_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date
AND pln.invk_flx_cr_pl_flag = 'N'
AND pln.imptd_incm_calc_cd IS NULL
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_COMPOBJ_CT oppd
WHERE oppd.plip_id = cpp.plip_id
AND oppd.oiplip_id = -1);
SELECT opp.oiplip_id oiplip_id, opp.oipl_id oipl_id, cop.opt_id opt_id,
opp.plip_id plip_id, cppd.pl_typ_id pl_typ_id,
cppd.ptip_id ptip_id, cppd.pl_id pl_id, cppd.pgm_id pgm_id, cop.ordr_num oipl_ordr_num
FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd
WHERE opp.plip_id = cppd.plip_id
AND cop.oipl_id = opp.oipl_id
AND l_effective_date BETWEEN opp.effective_start_date
AND opp.effective_end_date
AND l_effective_date BETWEEN cop.effective_start_date
AND cop.effective_end_date
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_COMPOBJ_CT oppd
WHERE oppd.oiplip_id = opp.oiplip_id);
SELECT rgr.popl_rptg_grp_id, rgr.rptg_grp_id, rgr.pgm_id
FROM ben_popl_rptg_grp_f rgr, hri_cs_co_pgm_ct pgmd
WHERE rgr.pgm_id IS NOT NULL
AND rgr.pgm_id = pgmd.pgm_id
AND l_effective_date BETWEEN rgr.effective_start_date
AND rgr.effective_end_date
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_CO_RPGH_PIRG_CT rgrd
WHERE rgrd.RPTGTYP_ID = rgr.rptg_grp_id
AND rgrd.pgm_id = rgr.pgm_id);
SELECT enp.enrt_perd_id, pgmd.pgm_id, enp.strt_dt, enp.end_dt, enp.ASND_LF_EVT_DT ASND_LF_EVT_DT
FROM hri_cs_co_pgm_ct pgmd,
ben_popl_enrt_typ_cycl_f pet,
ben_enrt_perd enp
WHERE pgmd.pgm_id = pet.pgm_id
AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
AND l_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_TIME_BENRL_PRD_CT enpd
WHERE enpd.enrt_perd_id = enp.enrt_perd_id);
SELECT enp.enrt_perd_id, enpd.pgm_id, enp.strt_dt, enp.end_dt,
enp.asnd_lf_evt_dt ASND_LF_EVT_DT
FROM hri_cs_time_benrl_prd_ct enpd,
ben_plip_f cpp,
ben_popl_enrt_typ_cycl_f pet,
ben_enrt_perd enp
WHERE enpd.pgm_id = cpp.pgm_id
AND pet.pl_id = cpp.pl_id
AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
AND enpd.ASND_LF_EVT_DT = enp.asnd_lf_evt_dt
AND l_effective_date BETWEEN cpp.effective_start_date
AND cpp.effective_end_date
AND l_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
AND NOT EXISTS (SELECT 'x'
FROM HRI_CS_TIME_BENRL_PRD_CT enpd
WHERE enpd.enrt_perd_id = enp.enrt_perd_id);
output('Inside Incremental Update');
INSERT INTO HRI_CS_CO_PGM_CT
( PGM_id
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_pgm_row.pgm_id
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_CO_PGMH_PTIP_CT
( ptip_id
, pl_typ_id
, PGM_ID
, ptip_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_ptip_row.ptip_id
, l_ptip_row.pl_typ_id
, l_ptip_row.PGM_ID
, l_ptip_row.ptip_ordr_num
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_CO_PGMH_PLIP_CT
( plip_id
, pl_id
, PGM_ID
, ptip_id
, pl_typ_id
, plip_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_plip_row.plip_id
, l_plip_row.pl_id
, l_plip_row.PGM_ID
, l_plip_row.ptip_id
, l_plip_row.pl_typ_id
, l_plip_row.plip_ordr_num
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_COMPOBJ_CT
( compobj_sk_pk
, oiplip_id
, oipl_id
, opt_id
, pl_id
, plip_id
, PGM_ID
, ptip_id
, pl_typ_id
, oipl_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( HRI_CS_COMPOBJ_CT_s.nextval
, l_oiplip_row.oiplip_id
, l_oiplip_row.oipl_id
, l_oiplip_row.opt_id
, l_oiplip_row.pl_id
, l_oiplip_row.plip_id
, l_oiplip_row.PGM_ID
, l_oiplip_row.ptip_id
, l_oiplip_row.pl_typ_id
, l_oiplip_row.oipl_ordr_num
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_COMPOBJ_CT
( compobj_sk_pk
, oiplip_id
, oipl_id
, opt_id
, pl_id
, plip_id
, PGM_ID
, ptip_id
, pl_typ_id
, oipl_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( HRI_CS_COMPOBJ_CT_s.nextval
, -1
, -1
, NULL
, l_plip_ernt_pl_row.pl_id
, l_plip_ernt_pl_row.plip_id
, l_plip_ernt_pl_row.PGM_ID
, l_plip_ernt_pl_row.ptip_id
, l_plip_ernt_pl_row.pl_typ_id
, NULL
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_CO_RPGH_PIRG_CT
( PIRG_SK_PK
, RPTGTYP_ID
, pgm_id
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( HRI_CS_CO_RPGH_PIRG_CT_S.nextval
, l_popl_rptg_grp_row.rptg_grp_id
, l_popl_rptg_grp_row.pgm_id
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
( enrt_perd_id
, pgm_id
, enrt_strt_dt
, enrt_thru_dt
, ASND_LF_EVT_DT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_enrt_perd_row.enrt_perd_id
, l_enrt_perd_row.pgm_id
, l_enrt_perd_row.strt_dt
, l_enrt_perd_row.end_dt
, l_enrt_perd_row.ASND_LF_EVT_DT
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
( enrt_perd_id
, pgm_id
, enrt_strt_dt
, enrt_thru_dt
, ASND_LF_EVT_DT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_pl_enrt_perd_row.enrt_perd_id
, l_pl_enrt_perd_row.pgm_id
, l_pl_enrt_perd_row.strt_dt
, l_pl_enrt_perd_row.end_dt
, l_pl_enrt_perd_row.ASND_LF_EVT_DT
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
DELETE FROM HRI_CS_CO_PGM_CT pgmd
WHERE NOT EXISTS (SELECT 'x'
FROM ben_pgm_f pgm
WHERE pgm.pgm_id = pgmd.pgm_id);
DELETE FROM HRI_CS_CO_PGMH_PTIP_CT ctpd
WHERE NOT EXISTS (SELECT 'x'
FROM ben_ptip_f ctp
WHERE ctp.ptip_id = ctpd.ptip_id);
DELETE FROM HRI_CS_CO_PGMH_PLIP_CT cppd
WHERE NOT EXISTS (SELECT 'x'
FROM ben_plip_f cpp
WHERE cpp.plip_id = cppd.plip_id);
DELETE FROM HRI_CS_COMPOBJ_CT oppd
WHERE oppd.oiplip_id <> -1
AND NOT EXISTS (SELECT 'x'
FROM ben_oiplip_f opp
WHERE opp.oiplip_id = oppd.oiplip_id);
DELETE FROM hri_cs_compobj_ct oppd
WHERE oppd.oiplip_id = -1
AND oppd.plip_id IS NOT NULL
AND ( NOT EXISTS (
SELECT 'x'
FROM ben_pl_f pln
WHERE pln.pl_id = oppd.pl_id
AND l_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date)
OR EXISTS (
SELECT 'x'
FROM ben_oipl_f cop, ben_pl_f pln
WHERE cop.pl_id = oppd.pl_id
AND cop.pl_id = pln.pl_id
AND l_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date
AND pln.enrt_pl_opt_flag = 'N'
AND l_effective_date BETWEEN cop.effective_start_date
AND cop.effective_end_date)
);
DELETE FROM HRI_CS_TIME_BENRL_PRD_CT enpd
WHERE NOT EXISTS (SELECT 'x'
FROM ben_enrt_perd enp
WHERE enp.enrt_perd_id = enpd.enrt_perd_id);
DELETE FROM HRI_CS_CO_RPGH_PIRG_CT rgrd
WHERE NOT EXISTS (SELECT 'x'
FROM ben_popl_rptg_grp_F rgr
WHERE rgr.rptg_grp_id = rgrd.RPTGTYP_ID
AND rgr.pgm_id = rgrd.pgm_id);
output('Removed Deleted Data: ' || to_char(sysdate,'HH24:MI:SS'));
END Incremental_Update;
SELECT pgm.pgm_id PGM_ID
FROM ben_pgm_f pgm
WHERE l_effective_date BETWEEN pgm.effective_start_date
AND pgm.effective_end_date
AND pgm.pgm_typ_cd in ('CORE', 'FLEX', 'FPC', 'OTHER')
AND EXISTS (
SELECT 'x'
FROM ben_popl_enrt_typ_cycl_f pet, ben_enrt_perd enp
WHERE pet.pgm_id = pgm.pgm_id
AND pet.enrt_typ_cycl_cd = 'O'
AND l_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id);
SELECT ctp.ptip_id ptip_id, ctp.pl_typ_id pl_typ_id, ctp.pgm_id pgm_id,
ctp.ordr_num ptip_ordr_num
FROM ben_ptip_f ctp, ben_pl_typ_f ptp
WHERE ctp.pl_typ_id = ptp.pl_typ_id
AND l_effective_date BETWEEN ctp.effective_start_date
AND ctp.effective_end_date
AND l_effective_date BETWEEN ptp.effective_start_date
AND ptp.effective_end_date
AND ptp.opt_typ_cd <> 'SPDGACCT'
AND EXISTS (SELECT 'x'
FROM hri_cs_co_pgm_ct pgmd
WHERE pgmd.pgm_id = ctp.pgm_id);
SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id, cpp.ordr_num plip_ordr_num
FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
WHERE cpp.pl_id = pln.pl_id
AND pln.pl_typ_id = ctpd.pl_typ_id
AND cpp.pgm_id = ctpd.pgm_id
AND pln.invk_flx_cr_pl_flag = 'N'
AND pln.imptd_incm_calc_cd IS NULL
AND l_effective_date BETWEEN cpp.effective_start_date
AND cpp.effective_end_date
AND l_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date;
SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,
ctpd.ptip_id ptip_id, ctpd.pl_typ_id pl_typ_id
FROM ben_plip_f cpp, ben_pl_f pln, hri_cs_co_pgmh_ptip_ct ctpd
WHERE cpp.pl_id = pln.pl_id
AND pln.pl_typ_id = ctpd.pl_typ_id
AND cpp.pgm_id = ctpd.pgm_id
AND ( pln.enrt_pl_opt_flag = 'Y'
OR NOT EXISTS (
SELECT 'x'
FROM ben_oipl_f cop
WHERE cop.pl_id = pln.pl_id
AND l_effective_date BETWEEN cop.effective_start_date
AND cop.effective_end_date)
)
AND l_effective_date BETWEEN cpp.effective_start_date
AND cpp.effective_end_date
AND l_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date
AND pln.invk_flx_cr_pl_flag = 'N'
AND pln.imptd_incm_calc_cd IS NULL;
SELECT opp.oiplip_id oiplip_id, opp.oipl_id oipl_id, cop.opt_id opt_id,
opp.plip_id plip_id, cppd.pl_typ_id pl_typ_id,
cppd.ptip_id ptip_id, cppd.pl_id pl_id, cppd.pgm_id pgm_id, cop.ordr_num oipl_ordr_num
FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd
WHERE opp.plip_id = cppd.plip_id
AND cop.oipl_id = opp.oipl_id
AND l_effective_date BETWEEN opp.effective_start_date
AND opp.effective_end_date
AND l_effective_date BETWEEN cop.effective_start_date
AND cop.effective_end_date;
SELECT rgr.popl_rptg_grp_id, rgr.rptg_grp_id, rgr.pgm_id
FROM ben_popl_rptg_grp_f rgr, hri_cs_co_pgm_ct pgmd
WHERE rgr.pgm_id IS NOT NULL
AND rgr.pgm_id = pgmd.pgm_id
AND l_effective_date BETWEEN rgr.effective_start_date
AND rgr.effective_end_date;
SELECT enp.enrt_perd_id, pgmd.pgm_id, enp.strt_dt, enp.end_dt, enp.ASND_LF_EVT_DT ASND_LF_EVT_DT
FROM hri_cs_co_pgm_ct pgmd,
ben_popl_enrt_typ_cycl_f pet,
ben_enrt_perd enp
WHERE pgmd.pgm_id = pet.pgm_id
AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
AND l_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
SELECT enp.enrt_perd_id, enpd.pgm_id, enp.strt_dt, enp.end_dt,
enp.asnd_lf_evt_dt ASND_LF_EVT_DT
FROM hri_cs_time_benrl_prd_ct enpd,
ben_plip_f cpp,
ben_popl_enrt_typ_cycl_f pet,
ben_enrt_perd enp
WHERE enpd.pgm_id = cpp.pgm_id
AND pet.pl_id = cpp.pl_id
AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
AND enpd.ASND_LF_EVT_DT = enp.asnd_lf_evt_dt
AND l_effective_date BETWEEN cpp.effective_start_date
AND cpp.effective_end_date
AND l_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
INSERT INTO HRI_CS_CO_PGM_CT
( PGM_id
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_pgm_row.pgm_id
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_CO_PGMH_PTIP_CT
( ptip_id
, pl_typ_id
, PGM_ID
, ptip_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_ptip_row.ptip_id
, l_ptip_row.pl_typ_id
, l_ptip_row.PGM_ID
, l_ptip_row.ptip_ordr_num
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_CO_PGMH_PLIP_CT
( plip_id
, pl_id
, PGM_ID
, ptip_id
, pl_typ_id
, plip_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_plip_row.plip_id
, l_plip_row.pl_id
, l_plip_row.PGM_ID
, l_plip_row.ptip_id
, l_plip_row.pl_typ_id
, l_plip_row.plip_ordr_num
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_COMPOBJ_CT
( compobj_sk_pk
, oiplip_id
, oipl_id
, opt_id
, pl_id
, plip_id
, PGM_ID
, ptip_id
, pl_typ_id
, oipl_ordr_num
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( HRI_CS_COMPOBJ_CT_s.nextval
, l_oiplip_row.oiplip_id
, l_oiplip_row.oipl_id
, l_oiplip_row.opt_id
, l_oiplip_row.pl_id
, l_oiplip_row.plip_id
, l_oiplip_row.PGM_ID
, l_oiplip_row.ptip_id
, l_oiplip_row.pl_typ_id
, l_oiplip_row.oipl_ordr_num
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_COMPOBJ_CT
( compobj_sk_pk
, oiplip_id
, oipl_id
, opt_id
, pl_id
, plip_id
, PGM_ID
, ptip_id
, pl_typ_id
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( HRI_CS_COMPOBJ_CT_s.nextval
, -1
, -1
, NULL
, l_plip_ernt_pl_row.pl_id
, l_plip_ernt_pl_row.plip_id
, l_plip_ernt_pl_row.PGM_ID
, l_plip_ernt_pl_row.ptip_id
, l_plip_ernt_pl_row.pl_typ_id
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_CO_RPGH_PIRG_CT
( PIRG_SK_PK
, RPTGTYP_ID
, pgm_id
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( HRI_CS_CO_RPGH_PIRG_CT_S.nextval
, l_popl_rptg_grp_row.rptg_grp_id
, l_popl_rptg_grp_row.pgm_id
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
( enrt_perd_id
, pgm_id
, enrt_strt_dt
, enrt_thru_dt
, ASND_LF_EVT_DT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_enrt_perd_row.enrt_perd_id
, l_enrt_perd_row.pgm_id
, l_enrt_perd_row.strt_dt
, l_enrt_perd_row.end_dt
, l_enrt_perd_row.ASND_LF_EVT_DT
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
( enrt_perd_id
, pgm_id
, enrt_strt_dt
, enrt_thru_dt
, ASND_LF_EVT_DT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
)
VALUES
( l_pl_enrt_perd_row.enrt_perd_id
, l_pl_enrt_perd_row.pgm_id
, l_pl_enrt_perd_row.strt_dt
, l_pl_enrt_perd_row.end_dt
, l_pl_enrt_perd_row.ASND_LF_EVT_DT
, l_current_time
, l_user_id
, l_login_id
, l_user_id
, l_current_time
);
Incremental_Update;