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 1265: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

1261: CURSOR c_pl_popl_yr_period_current(cv_pl_id number,
1262: cv_pgm_id number,
1263: cv_lf_evt_ocrd_dt date ) IS
1264: SELECT distinct yp.start_date
1265: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
1266: WHERE ( pyp.pl_id = cv_pl_id or pyp.pgm_id = cv_pgm_id )
1267: AND pyp.yr_perd_id = yp.yr_perd_id
1268: AND pyp.business_group_id = p_business_group_id
1269: AND cv_lf_evt_ocrd_dt BETWEEN yp.start_date AND yp.end_date

Line 3976: FROM ben_popl_yr_perd pyp, ben_yr_perd yp

3972:
3973: CURSOR c_pl_popl_yr_period_current IS
3974: SELECT yp.end_date,
3975: pyp.ordr_num
3976: FROM ben_popl_yr_perd pyp, ben_yr_perd yp
3977: WHERE pyp.pl_id = p_pl_id
3978: AND pyp.yr_perd_id = yp.yr_perd_id
3979: AND pyp.business_group_id = p_business_group_id
3980: AND p_lf_evt_ocrd_dt BETWEEN yp.start_date AND yp.end_date