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

Line 1131: l_tsp_pgm_id ben_pgm_f.pgm_id%type;

1127: l_payroll_id per_all_assignments_f.payroll_id%type;
1128: l_pgm_year_end_dt Date;
1129: --l_date_of_birth Date;
1130: l_tspc_rate_start_dt Date;
1131: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1132: l_pl_id ben_pl_f.pl_id%type;
1133: l_oipl_id ben_oipl_f.oipl_id%type;
1134: l_opt_name ben_opt_f.name%type;
1135:

Line 1184: from ben_pgm_f

1180: */
1181: -- Cursor to get program id for TSP
1182: Cursor c_get_tsp_pgm_id is
1183: select pgm_id
1184: from ben_pgm_f
1185: where name = 'Federal Thrift Savings Plan (TSP)'
1186: and business_group_id = p_business_group_id
1187: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1188: