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_RUN_RESULTS

Line 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

272: paya.action_type action_type,
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

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 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

314: 'L' action_type, ---- retro
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

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