DBA Data[Home] [Help]

APPS.PAY_IE_MEDICAL_ADJUST dependencies on PAY_RUN_RESULTS

Line 211: pay_run_results prr,

207: p_input_val_id_tax in number) IS
208: select paa.assignment_id, sum(fnd_number.canonical_to_number(prrv1.result_value)) result_value --paa.assignment_action_id, paa.payroll_action_id
209: from pay_assignment_actions paa,
210: pay_payroll_actions ppa,
211: pay_run_results prr,
212: pay_run_result_values prrv,
213: pay_run_result_values prrv1
214: where paa.action_status = 'C'
215: and paa.payroll_action_id = ppa.payroll_action_id

Line 236: and run_result_id in (select run_result_id from pay_run_results

232: p_input_val_id in number,
233: p_assg_act_id in number) IS
234: select result_value from pay_run_result_values where
235: input_value_id = p_input_val_id
236: and run_result_id in (select run_result_id from pay_run_results
237: where assignment_action_id = p_assg_act_id
238: and element_type_id = p_ele_type_id) ;
239:
240: -- Get person details