APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ENRT_RT

Line 777: 28-Aug-01 kmahendr 115.252 updating of ben_enrt_rt in U mode

773: 02-Aug-01 ikasire 115.251 Bug 1895846 added two new procedures
774: delete_in_pndg_elig_dpnt and
775: reset_elctbl_chc_inpng_flag
776: see bug for more details
777: 28-Aug-01 kmahendr 115.252 updating of ben_enrt_rt in U mode
778: removed - Bug#1936976
779: 11-Aug-01 kmahendr 115.253 Bug#1900657-Added codes in procedure
780: process_comp_objects
781: 25-Sep-01 kmahendr 115.254 Made changes for R mode - private

Line 2424: from ben_enrt_rt

2420: procedure update_enrt_rt (p_per_in_ler_id number) is
2421: --
2422: cursor c_enrt_rt is
2423: select *
2424: from ben_enrt_rt
2425: where elig_per_elctbl_chc_id in
2426: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2427: where per_in_ler_id = p_per_in_ler_id)
2428: union

Line 2430: from ben_enrt_rt

2426: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2427: where per_in_ler_id = p_per_in_ler_id)
2428: union
2429: select *
2430: from ben_enrt_rt
2431: where enrt_bnft_id in
2432: (select enrt_bnft_id from ben_enrt_bnft
2433: where elig_per_elctbl_chc_id in
2434: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

Line 2491: update ben_enrt_rt

2487: end if;
2488: if i.acty_base_rt_id = ben_manage_life_events.g_enrt_rt_tbl(j).acty_base_rt_id then
2489: --
2490: if ben_manage_life_events.g_enrt_rt_tbl(j).prtt_rt_val_id is not null then
2491: update ben_enrt_rt
2492: set prtt_rt_val_id = ben_manage_life_events.g_enrt_rt_tbl(j).prtt_rt_val_id
2493: where enrt_rt_id = i.enrt_rt_id;
2494: end if;
2495: --

Line 3891: from ben_enrt_rt ecr

3887: and effective_end_date;
3888: --
3889: cursor c_ecr(cv_elig_per_elctbl_chc_id in number) is
3890: select ecr.*
3891: from ben_enrt_rt ecr
3892: where ecr.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id;
3893: --
3894: l_curr_pel c_pel%rowtype;
3895: l_curr_epe c_epe%rowtype;

Line 4143: INSERT INTO ben_enrt_rt

4139: --
4140: for l_ecr_rec in c_ecr(l_curr_epe.elig_per_elctbl_chc_id)
4141: loop
4142: --
4143: INSERT INTO ben_enrt_rt
4144: (
4145: enrt_rt_id,
4146: acty_typ_cd,
4147: tx_typ_cd,

Line 4236: ben_enrt_rt_s.nextval,

4232: program_id,
4233: program_update_date,
4234: object_version_number)
4235: VALUES(
4236: ben_enrt_rt_s.nextval,
4237: l_ecr_rec.acty_typ_cd,
4238: l_ecr_rec.tx_typ_cd,
4239: l_ecr_rec.ctfn_rqd_flag,
4240: l_ecr_rec.dflt_flag,

Line 4407: from ben_enrt_rt ecr

4403: and effective_end_date;
4404: --
4405: cursor c_ecr(cv_elig_per_elctbl_chc_id in number) is
4406: select ecr.*
4407: from ben_enrt_rt ecr
4408: where ecr.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id;
4409: --
4410: l_curr_epe c_epe%rowtype;
4411: --

Line 4665: INSERT INTO ben_enrt_rt

4661: --
4662: for l_ecr_rec in c_ecr(l_curr_epe.elig_per_elctbl_chc_id)
4663: loop
4664: --
4665: INSERT INTO ben_enrt_rt
4666: (
4667: enrt_rt_id,
4668: acty_typ_cd,
4669: tx_typ_cd,

Line 4757: ben_enrt_rt_s.nextval,

4753: program_id,
4754: program_update_date,
4755: object_version_number)
4756: VALUES(
4757: ben_enrt_rt_s.nextval,
4758: l_ecr_rec.acty_typ_cd,
4759: l_ecr_rec.tx_typ_cd,
4760: l_ecr_rec.ctfn_rqd_flag,
4761: l_ecr_rec.dflt_flag,