APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PL_TYP_F

Line 2772: FROM ben_pl_typ_f bpt

2768: ------------Bug 8846328
2769: CURSOR c_pl_typ IS
2770: SELECT bpt.effective_start_date,
2771: bpt.effective_end_date
2772: FROM ben_pl_typ_f bpt
2773: WHERE bpt.pl_typ_id = l_pl_typ_id
2774: AND l_lf_evt_ocrd_dt BETWEEN bpt.effective_start_date
2775: AND bpt.effective_end_date
2776: AND bpt.business_group_id = p_business_group_id;

Line 3584: from ben_pl_typ_f pl_typ

3580: ;
3581: --
3582: cursor c_pl_typ_requery(p_id number,p_ed date) is
3583: select 'Y'
3584: from ben_pl_typ_f pl_typ
3585: where pl_typ_id=p_id and
3586: business_group_id=p_business_group_id and
3587: p_ed between effective_start_date and effective_end_date
3588: ;