DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_POPL_YR_PERD

Line 2793: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

2789: pyp.popl_yr_perd_id,
2790: yp.start_date,
2791: yp.end_date,
2792: pyp.ordr_num
2793: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
2794: WHERE pyp.pl_id = l_pl_id
2795: AND pyp.yr_perd_id = yp.yr_perd_id
2796: AND pyp.business_group_id = p_business_group_id
2797: AND l_lf_evt_ocrd_dt BETWEEN yp.start_date AND yp.end_date

Line 8352: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

8348: SELECT pyp.yr_perd_id,
8349: pyp.popl_yr_perd_id,
8350: yp.start_date,
8351: yp.end_date
8352: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
8353: WHERE pyp.pl_id = p_pl_id
8354: AND pyp.business_group_id = p_business_group_id
8355: AND pyp.ordr_num = p_popl_yr_perd_ordr_num
8356: AND yp.business_group_id = p_business_group_id