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 2384: from ben_pgm_f

2380: abr.effective_start_date and abr.effective_end_date;
2381: -- bug 2988218
2382: cursor c_pgm_type is
2383: select pgm_typ_cd
2384: from ben_pgm_f
2385: where pgm_id = p_pgm_id
2386: and business_group_id = p_business_group_id
2387: and p_effective_date between
2388: effective_start_date and effective_end_date;

Line 6785: from ben_pgm_f pgm

6781: l_rt_strt_dt date;
6782: --
6783: cursor c_pgm is
6784: select 'Y'
6785: from ben_pgm_f pgm
6786: where pgm.pgm_id = p_pgm_id
6787: and pgm.business_group_id = p_business_group_id
6788: and pgm.pgm_typ_cd in ('FLEX','FPC')
6789: and p_effective_date between