APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ENRT_PERD

Line 1735: from ben_enrt_perd enp,

1731: cursor c3 is
1732: select enp.uses_bdgt_flag,
1733: enp.prsvr_bdgt_cd,
1734: DECODE(pln.pl_id,pln.group_pl_id,'Y','N') Group_plan
1735: from ben_enrt_perd enp,
1736: ben_popl_enrt_typ_cycl_f pet,
1737: ben_pl_f pln
1738: where pet.pl_id = p_pl_id
1739: and pet.business_group_id = p_business_group_id

Line 7849: ben_enrt_perd enp,

7845: --
7846: cursor c_popl_enrt_typ_cycl is
7847: select ler.ler_id, pet.popl_enrt_typ_cycl_id
7848: from ben_popl_enrt_typ_cycl_f pet,
7849: ben_enrt_perd enp,
7850: ben_ler_f ler
7851: where enp.business_group_id = p_business_group_id
7852: -- PB : 5422 :
7853: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt

Line 10124: from ben_enrt_perd

10120: --
10121: /*
10122: cursor c_strt_dt is
10123: select strt_dt
10124: from ben_enrt_perd
10125: where enrt_perd_id = p_popl_enrt_typ_cycl_id;
10126: */
10127: --
10128: cursor c_get_inelig_dpnt_info(p_per_in_ler_id in number) is

Line 10506: ben_enrt_perd enrtp,

10502: select 1 ordr_num ,
10503: enrtp.enrt_perd_id,
10504: NVL(enrtp.defer_deenrol_flag,'N')
10505: FROM ben_popl_enrt_typ_cycl_f petc,
10506: ben_enrt_perd enrtp,
10507: ben_ler_f ler
10508: WHERE petc.pl_id = c_pl_id
10509: AND petc.business_group_id = p_business_group_id
10510: AND c_effective_date BETWEEN petc.effective_start_date

Line 10526: ben_enrt_perd enrtp,

10522: select 2 ordr_num ,
10523: enrtp.enrt_perd_id,
10524: NVL(enrtp.defer_deenrol_flag,'N')
10525: FROM ben_popl_enrt_typ_cycl_f petc,
10526: ben_enrt_perd enrtp,
10527: ben_ler_f ler
10528: WHERE petc.pgm_id = c_pgm_id
10529: AND petc.business_group_id = p_business_group_id
10530: AND c_effective_date BETWEEN petc.effective_start_date