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_ELECTION_INFORMATION dependencies on BEN_POPL_YR_PERD

Line 1427: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

1423: CURSOR c_pl_popl_yr_period_current(cv_pl_id number,
1424: cv_pgm_id number,
1425: cv_lf_evt_ocrd_dt date ) IS
1426: SELECT distinct yp.start_date
1427: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
1428: WHERE ( pyp.pl_id = cv_pl_id or pyp.pgm_id = cv_pgm_id )
1429: AND pyp.yr_perd_id = yp.yr_perd_id
1430: AND pyp.business_group_id = p_business_group_id
1431: AND cv_lf_evt_ocrd_dt BETWEEN yp.start_date AND yp.end_date

Line 4473: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

4469:
4470: CURSOR c_pl_popl_yr_period_current IS
4471: SELECT yp.end_date,
4472: pyp.ordr_num
4473: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
4474: WHERE pyp.pl_id = p_pl_id
4475: AND pyp.yr_perd_id = yp.yr_perd_id
4476: AND pyp.business_group_id = p_business_group_id
4477: AND p_lf_evt_ocrd_dt BETWEEN yp.start_date AND yp.end_date