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 2816: from ben_enrt_rt

2812: procedure update_enrt_rt (p_per_in_ler_id number) is
2813: --
2814: cursor c_enrt_rt is
2815: select *
2816: from ben_enrt_rt
2817: where elig_per_elctbl_chc_id in
2818: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2819: where per_in_ler_id = p_per_in_ler_id)
2820: union

Line 2822: from ben_enrt_rt

2818: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2819: where per_in_ler_id = p_per_in_ler_id)
2820: union
2821: select *
2822: from ben_enrt_rt
2823: where enrt_bnft_id in
2824: (select enrt_bnft_id from ben_enrt_bnft
2825: where elig_per_elctbl_chc_id in
2826: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

Line 2883: update ben_enrt_rt

2879: end if;
2880: if i.acty_base_rt_id = ben_manage_life_events.g_enrt_rt_tbl(j).acty_base_rt_id then
2881: --
2882: if ben_manage_life_events.g_enrt_rt_tbl(j).prtt_rt_val_id is not null then
2883: update ben_enrt_rt
2884: set prtt_rt_val_id = ben_manage_life_events.g_enrt_rt_tbl(j).prtt_rt_val_id
2885: where enrt_rt_id = i.enrt_rt_id;
2886: end if;
2887: --

Line 4283: from ben_enrt_rt ecr

4279: and effective_end_date;
4280: --
4281: cursor c_ecr(cv_elig_per_elctbl_chc_id in number) is
4282: select ecr.*
4283: from ben_enrt_rt ecr
4284: where ecr.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id;
4285: --
4286: l_curr_pel c_pel%rowtype;
4287: l_curr_epe c_epe%rowtype;

Line 4535: INSERT INTO ben_enrt_rt

4531: --
4532: for l_ecr_rec in c_ecr(l_curr_epe.elig_per_elctbl_chc_id)
4533: loop
4534: --
4535: INSERT INTO ben_enrt_rt
4536: (
4537: enrt_rt_id,
4538: acty_typ_cd,
4539: tx_typ_cd,

Line 4628: ben_enrt_rt_s.nextval,

4624: program_id,
4625: program_update_date,
4626: object_version_number)
4627: VALUES(
4628: ben_enrt_rt_s.nextval,
4629: l_ecr_rec.acty_typ_cd,
4630: l_ecr_rec.tx_typ_cd,
4631: l_ecr_rec.ctfn_rqd_flag,
4632: l_ecr_rec.dflt_flag,

Line 4799: from ben_enrt_rt ecr

4795: and effective_end_date;
4796: --
4797: cursor c_ecr(cv_elig_per_elctbl_chc_id in number) is
4798: select ecr.*
4799: from ben_enrt_rt ecr
4800: where ecr.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id;
4801: --
4802: l_curr_epe c_epe%rowtype;
4803: --

Line 5057: INSERT INTO ben_enrt_rt

5053: --
5054: for l_ecr_rec in c_ecr(l_curr_epe.elig_per_elctbl_chc_id)
5055: loop
5056: --
5057: INSERT INTO ben_enrt_rt
5058: (
5059: enrt_rt_id,
5060: acty_typ_cd,
5061: tx_typ_cd,

Line 5149: ben_enrt_rt_s.nextval,

5145: program_id,
5146: program_update_date,
5147: object_version_number)
5148: VALUES(
5149: ben_enrt_rt_s.nextval,
5150: l_ecr_rec.acty_typ_cd,
5151: l_ecr_rec.tx_typ_cd,
5152: l_ecr_rec.ctfn_rqd_flag,
5153: l_ecr_rec.dflt_flag,

Line 10293: from ben_enrt_rt

10289: enrt_bnft_id,
10290: object_version_number,
10291: acty_base_rt_id,
10292: null mark_delete
10293: from ben_enrt_rt
10294: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
10295: union
10296: select enrt_rt_id,
10297: elig_per_elctbl_chc_id,

Line 10302: from ben_enrt_rt

10298: enrt_bnft_id,
10299: object_version_number,
10300: acty_base_rt_id,
10301: null mark_delete
10302: from ben_enrt_rt
10303: where enrt_bnft_id in (select enrt_bnft_id
10304: from ben_enrt_bnft
10305: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
10306: );