APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ENRT_PERD

Line 2776: -- from ben_enrt_perd_for_pl_f epp

2772: --
2773: --cursor c_enrt_perd_for_pl_info is
2774: -- select epp.enrt_cvg_strt_dt_cd,
2775: -- epp.enrt_cvg_strt_dt_rl
2776: -- from ben_enrt_perd_for_pl_f epp
2777: -- where epp.pl_id=l_pl_id and
2778: -- (epp.enrt_perd_id=l_pgme_enrt_perd_id or
2779: -- epp.lee_rsn_id=l_pgme_lee_rsn_id) and
2780: -- nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 3143: ben_enrt_perd enrtp,

3139: enrtp.pos_structure_version_id,
3140: /* bug 2746865 */
3141: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3142: FROM ben_popl_enrt_typ_cycl_f petc,
3143: ben_enrt_perd enrtp,
3144: ben_ler_f ler
3145: WHERE petc.pl_id = l_pl_id
3146: AND petc.business_group_id = p_business_group_id
3147: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date

Line 3182: ben_enrt_perd enrtp,

3178: enrtp.pos_structure_version_id,
3179: /* bug 2746865*/
3180: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3181: FROM ben_popl_enrt_typ_cycl_f petc,
3182: ben_enrt_perd enrtp,
3183: ben_ler_f ler
3184: WHERE petc.pgm_id = p_pgm_id
3185: AND petc.business_group_id = p_business_group_id
3186: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date