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.PSP_PAYTRN dependencies on PAY_ELEMENT_TYPES_F

Line 277: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,

273: ptp.start_date tp_start_date,
274: ptp.end_date tp_end_date,
275: ptp.time_period_id,
276: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
277: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
278: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
279: pay_input_values_f piv
280: WHERE a.assignment_action_id = l_assignment_action_id and
281: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND

Line 319: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,

315: ptp.start_date tp_start_date,
316: ptp.end_date tp_end_date,
317: ptp.time_period_id,
318: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
319: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
320: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
321: pay_input_values_f piv
322: WHERE a.assignment_action_id = l_assignment_action_id and
323: SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND

Line 9029: l_element_name pay_element_types_f.element_name%TYPE;

9025: l_business_days NUMBER;
9026: l_sub_line_id NUMBER;
9027: l_payroll_line_id NUMBER;
9028: l_rowid VARCHAR2(20);
9029: l_element_name pay_element_types_f.element_name%TYPE;
9030: l_temp_start_date DATE;
9031: l_temp_end_date DATE;
9032:
9033: BEGIN