eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_YR_PERD

Line 2824: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

2820: pyp.popl_yr_perd_id,
2821: yp.start_date,
2822: yp.end_date,
2823: pyp.ordr_num
2824: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
2825: WHERE pyp.pl_id = l_pl_id
2826: AND pyp.yr_perd_id = yp.yr_perd_id
2827: AND pyp.business_group_id = p_business_group_id
2828: AND l_lf_evt_ocrd_dt BETWEEN yp.start_date AND yp.end_date

Line 8491: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

8487: SELECT pyp.yr_perd_id,
8488: pyp.popl_yr_perd_id,
8489: yp.start_date,
8490: yp.end_date
8491: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
8492: WHERE pyp.pl_id = p_pl_id
8493: AND pyp.business_group_id = p_business_group_id
8494: AND pyp.ordr_num = p_popl_yr_perd_ordr_num
8495: AND yp.business_group_id = p_business_group_id