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 1127: l_tsp_pgm_id ben_pgm_f.pgm_id%type;

1123: l_payroll_id per_all_assignments_f.payroll_id%type;
1124: l_pgm_year_end_dt Date;
1125: --l_date_of_birth Date;
1126: l_tspc_rate_start_dt Date;
1127: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1128: l_pl_id ben_pl_f.pl_id%type;
1129: l_oipl_id ben_oipl_f.oipl_id%type;
1130: l_opt_name ben_opt_f.name%type;
1131:

Line 1180: from ben_pgm_f

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