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.HR_PUMP_GET dependencies on BEN_PGM_F

Line 2068: from ben_pgm_f pgm

2064: l_pgm_id number;
2065: begin
2066: select pgm.pgm_id
2067: into l_pgm_id
2068: from ben_pgm_f pgm
2069: where pgm.name = p_program
2070: and pgm.business_group_id + 0 = p_business_group_id
2071: and p_effective_date between
2072: pgm.effective_start_date and pgm.effective_end_date;

Line 2090: from ben_pgm_f pgm

2086: l_ovn number;
2087: begin
2088: select pgm.object_version_number
2089: into l_ovn
2090: from ben_pgm_f pgm
2091: where pgm.name = p_program
2092: and pgm.business_group_id + 0 = p_business_group_id
2093: and p_effective_date between
2094: pgm.effective_start_date and pgm.effective_end_date;

Line 3677: from ben_pgm_f pgm

3673: l_grade_ladder_pgm_id number;
3674: begin
3675: select pgm.pgm_id
3676: into l_grade_ladder_pgm_id
3677: from ben_pgm_f pgm
3678: where pgm.name = p_grade_ladder_name
3679: and pgm.pgm_typ_cd = 'GSP'
3680: and pgm.business_group_id + 0 = p_business_group_id
3681: and p_effective_date