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_PROVIDER_POOLS dependencies on BEN_PGM_F

Line 2253: from ben_pgm_f

2249: abr.effective_start_date and abr.effective_end_date;
2250: -- bug 2988218
2251: cursor c_pgm_type is
2252: select pgm_typ_cd
2253: from ben_pgm_f
2254: where pgm_id = p_pgm_id
2255: and business_group_id = p_business_group_id
2256: and p_effective_date between
2257: effective_start_date and effective_end_date;

Line 6608: from ben_pgm_f pgm

6604: l_rt_strt_dt date;
6605: --
6606: cursor c_pgm is
6607: select 'Y'
6608: from ben_pgm_f pgm
6609: where pgm.pgm_id = p_pgm_id
6610: and pgm.business_group_id = p_business_group_id
6611: and pgm.pgm_typ_cd in ('FLEX','FPC')
6612: and p_effective_date between