DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_RUN_RESULTS

Line 175: , pay_run_results prr

171: , pay_element_types_f et
172: , pay_input_values_f iv
173: , pay_input_values_f iv1
174: , pay_input_values_f iv2
175: , pay_run_results prr
176: , pay_run_results prr1
177: , pay_run_results prr2
178: , pay_run_result_values prrv
179: , pay_run_result_values prrv1

Line 176: , pay_run_results prr1

172: , pay_input_values_f iv
173: , pay_input_values_f iv1
174: , pay_input_values_f iv2
175: , pay_run_results prr
176: , pay_run_results prr1
177: , pay_run_results prr2
178: , pay_run_result_values prrv
179: , pay_run_result_values prrv1
180: , pay_run_result_values prrv2

Line 177: , pay_run_results prr2

173: , pay_input_values_f iv1
174: , pay_input_values_f iv2
175: , pay_run_results prr
176: , pay_run_results prr1
177: , pay_run_results prr2
178: , pay_run_result_values prrv
179: , pay_run_result_values prrv1
180: , pay_run_result_values prrv2
181: , pay_assignment_actions assact

Line 235: ,pay_run_results prr4

231: )
232: and assact.assignment_action_id = ( select max(assact4.assignment_action_id)
233: from pay_assignment_actions assact4
234: ,pay_payroll_actions pact4
235: ,pay_run_results prr4
236: where assact4.assignment_id = a.assignment_id
237: and assact4.assignment_action_id = prr4.assignment_action_id
238: and pact4.payroll_action_id = assact4.payroll_action_id
239: and pact4.effective_date between to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')