APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ENRT_PERD

Line 1343: from ben_enrt_perd enp,

1339: cursor c3 is
1340: select enp.uses_bdgt_flag,
1341: enp.prsvr_bdgt_cd,
1342: DECODE(pln.pl_id,pln.group_pl_id,'Y','N') Group_plan
1343: from ben_enrt_perd enp,
1344: ben_popl_enrt_typ_cycl_f pet,
1345: ben_pl_f pln
1346: where pet.pl_id = p_pl_id
1347: and pet.business_group_id = p_business_group_id

Line 7443: ben_enrt_perd enp,

7439: --
7440: cursor c_popl_enrt_typ_cycl is
7441: select ler.ler_id, pet.popl_enrt_typ_cycl_id
7442: from ben_popl_enrt_typ_cycl_f pet,
7443: ben_enrt_perd enp,
7444: ben_ler_f ler
7445: where enp.business_group_id = p_business_group_id
7446: -- PB : 5422 :
7447: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt

Line 9716: from ben_enrt_perd

9712: --
9713: /*
9714: cursor c_strt_dt is
9715: select strt_dt
9716: from ben_enrt_perd
9717: where enrt_perd_id = p_popl_enrt_typ_cycl_id;
9718: */
9719: --
9720: cursor c_get_inelig_dpnt_info(p_per_in_ler_id in number) is

Line 10050: ben_enrt_perd enrtp,

10046: select 1 ordr_num ,
10047: enrtp.enrt_perd_id,
10048: NVL(enrtp.defer_deenrol_flag,'N')
10049: FROM ben_popl_enrt_typ_cycl_f petc,
10050: ben_enrt_perd enrtp,
10051: ben_ler_f ler
10052: WHERE petc.pl_id = c_pl_id
10053: AND petc.business_group_id = p_business_group_id
10054: AND c_effective_date BETWEEN petc.effective_start_date

Line 10070: ben_enrt_perd enrtp,

10066: select 2 ordr_num ,
10067: enrtp.enrt_perd_id,
10068: NVL(enrtp.defer_deenrol_flag,'N')
10069: FROM ben_popl_enrt_typ_cycl_f petc,
10070: ben_enrt_perd enrtp,
10071: ben_ler_f ler
10072: WHERE petc.pgm_id = c_pgm_id
10073: AND petc.business_group_id = p_business_group_id
10074: AND c_effective_date BETWEEN petc.effective_start_date