DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PL_TYP_F

Line 2741: FROM ben_pl_typ_f bpt

2737: --
2738: CURSOR c_pl_typ IS
2739: SELECT bpt.effective_start_date,
2740: bpt.effective_end_date
2741: FROM ben_pl_typ_f bpt
2742: WHERE bpt.pl_typ_id = l_pl_typ_id
2743: AND l_lf_evt_ocrd_dt BETWEEN bpt.effective_start_date
2744: AND bpt.effective_end_date
2745: AND bpt.business_group_id = p_business_group_id;

Line 3538: from ben_pl_typ_f pl_typ

3534: ;
3535: --
3536: cursor c_pl_typ_requery(p_id number,p_ed date) is
3537: select 'Y'
3538: from ben_pl_typ_f pl_typ
3539: where pl_typ_id=p_id and
3540: business_group_id=p_business_group_id and
3541: p_ed between effective_start_date and effective_end_date
3542: ;