APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 1736: ben_popl_enrt_typ_cycl_f pet,

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
1740: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id

Line 7848: from ben_popl_enrt_typ_cycl_f pet,

7844: pl.effective_end_date;
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 :

Line 10470: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10466: c_effective_date date) is
10467: select 1 ordr_num ,
10468: leer.lee_rsn_id,
10469: NVL(leer.defer_deenrol_flag,'N')
10470: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10471: WHERE leer.ler_id = p_ler_id
10472: AND leer.business_group_id = p_business_group_id
10473: AND c_effective_date BETWEEN leer.effective_start_date
10474: AND leer.effective_end_date

Line 10485: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10481: UNION
10482: select 2 ordr_num ,
10483: leer.lee_rsn_id,
10484: NVL(leer.defer_deenrol_flag,'N')
10485: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10486: WHERE leer.ler_id = p_ler_id
10487: AND leer.business_group_id = p_business_group_id
10488: AND c_effective_date BETWEEN leer.effective_start_date
10489: AND leer.effective_end_date

Line 10505: FROM ben_popl_enrt_typ_cycl_f petc,

10501: c_effective_date date) is
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

Line 10525: FROM ben_popl_enrt_typ_cycl_f petc,

10521: UNION
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