DBA Data[Home] [Help]

APPS.PAY_NZ_REC_PKG dependencies on PAY_RUN_RESULTS

Line 133: pay_run_results prr,

129:
130: select sum(prrv.result_value)
131: from pay_payroll_actions ppa,
132: pay_assignment_actions pac,
133: pay_run_results prr,
134: pay_run_result_values prrv,
135: pay_element_types_f pet,
136: pay_input_values_f piv
137: where ppa.payroll_action_id = c_payroll_action_id

Line 195: , pay_run_results prr

191: IS
192: SELECT SUM(prrv.result_value)
193: FROM pay_payroll_actions ppa
194: , pay_assignment_actions pac
195: , pay_run_results prr
196: , pay_run_result_values prrv
197: , pay_element_types_f pet
198: , pay_input_values_f piv
199: WHERE pac.assignment_id = c_assignment_id

Line 276: pay_run_results prr

272: pay_input_values_f piv,
273: pay_balance_feeds_f pbf,
274: pay_payroll_actions ppa,
275: pay_assignment_actions pac,
276: pay_run_results prr
277: where ppa.payroll_action_id = c_payroll_action_id
278: and pet.element_type_id = c_element_type_id
279: and pac.assignment_id = c_assignment_id
280: and piv.name = v_input_value_name