APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ENRT_PERD

Line 2807: -- from ben_enrt_perd_for_pl_f epp

2803: --
2804: --cursor c_enrt_perd_for_pl_info is
2805: -- select epp.enrt_cvg_strt_dt_cd,
2806: -- epp.enrt_cvg_strt_dt_rl
2807: -- from ben_enrt_perd_for_pl_f epp
2808: -- where epp.pl_id=l_pl_id and
2809: -- (epp.enrt_perd_id=l_pgme_enrt_perd_id or
2810: -- epp.lee_rsn_id=l_pgme_lee_rsn_id) and
2811: -- nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 3189: ben_enrt_perd enrtp,

3185: enrtp.pos_structure_version_id,
3186: /* bug 2746865 */
3187: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3188: FROM ben_popl_enrt_typ_cycl_f petc,
3189: ben_enrt_perd enrtp,
3190: ben_ler_f ler
3191: WHERE petc.pl_id = l_pl_id
3192: AND petc.business_group_id = p_business_group_id
3193: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date

Line 3228: ben_enrt_perd enrtp,

3224: enrtp.pos_structure_version_id,
3225: /* bug 2746865*/
3226: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3227: FROM ben_popl_enrt_typ_cycl_f petc,
3228: ben_enrt_perd enrtp,
3229: ben_ler_f ler
3230: WHERE petc.pgm_id = p_pgm_id
3231: AND petc.business_group_id = p_business_group_id
3232: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date