APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 1344: ben_popl_enrt_typ_cycl_f pet,

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

Line 7442: from ben_popl_enrt_typ_cycl_f pet,

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

Line 10014: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10010: c_effective_date date) is
10011: select 1 ordr_num ,
10012: leer.lee_rsn_id,
10013: NVL(leer.defer_deenrol_flag,'N')
10014: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10015: WHERE leer.ler_id = p_ler_id
10016: AND leer.business_group_id = p_business_group_id
10017: AND c_effective_date BETWEEN leer.effective_start_date
10018: AND leer.effective_end_date

Line 10029: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc

10025: UNION
10026: select 2 ordr_num ,
10027: leer.lee_rsn_id,
10028: NVL(leer.defer_deenrol_flag,'N')
10029: FROM ben_lee_rsn_f leer, ben_popl_enrt_typ_cycl_f petc
10030: WHERE leer.ler_id = p_ler_id
10031: AND leer.business_group_id = p_business_group_id
10032: AND c_effective_date BETWEEN leer.effective_start_date
10033: AND leer.effective_end_date

Line 10049: FROM ben_popl_enrt_typ_cycl_f petc,

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

Line 10069: FROM ben_popl_enrt_typ_cycl_f petc,

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