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_NON_SF52_EXTRA_INFO dependencies on PER_TIME_PERIODS

Line 1190: l_start_date per_time_periods.start_date%type;

1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;
1191: l_family_code ghr_pa_requests.noa_family_code%type;
1192: l_new_element_name pay_element_types_f.element_name%type;
1193: l_bus_group_id per_all_people_f.business_group_id%type;
1194: l_fehb_exists BOOLEAN;

Line 1222: FROM per_time_periods

1218: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
1219:
1220: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS
1221: SELECT min(start_date) start_date
1222: FROM per_time_periods
1223: WHERE payroll_id = c_payroll_id
1224: AND TO_CHAR(start_date,'YYYY') = c_year
1225: AND TO_CHAR(start_date,'MM') = c_month;
1226: