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 274: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id

270: paya.action_type action_type,
271: ptp.start_date tp_start_date,
272: ptp.end_date tp_end_date,
273: ptp.time_period_id,
274: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
275: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
276: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
277: pay_input_values_f piv
278: WHERE a.assignment_action_id = l_assignment_action_id and

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

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

Line 316: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id

312: 'L' action_type, ---- retro
313: ptp.start_date tp_start_date,
314: ptp.end_date tp_end_date,
315: ptp.time_period_id,
316: NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
317: FROM PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
318: pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
319: pay_input_values_f piv
320: WHERE a.assignment_action_id = l_assignment_action_id and

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

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