DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PAY_RUN_RESULTS

Line 2430: pay_run_results prr,

2426: ,c_element_name IN VARCHAR2
2427: ,c_input_name IN VARCHAR2) IS
2428: SELECT prv.result_value
2429: FROM pay_run_result_values prv,
2430: pay_run_results prr,
2431: pay_input_values_f piv,
2432: pay_element_types_f pet
2433: WHERE prv.run_result_id = prr.run_result_id
2434: AND prr.assignment_action_id = c_assignment_action_id

Line 2702: FROM pay_run_results prr

2698: ,p_carry_over_id NUMBER
2699: ,p_exempted_id NUMBER)
2700: IS
2701: SELECT count(*)
2702: FROM pay_run_results prr
2703: ,pay_run_result_values prrv1
2704: ,pay_run_result_values prrv2
2705: ,pay_assignment_actions paa
2706: ,pay_payroll_actions ppa

Line 4626: FROM pay_run_results prr,

4622: AND prev_asg.action_sequence <= cur_asg.action_sequence
4623: AND cur_pay.effective_date between ptp.start_date and ptp.end_date
4624: AND ptp.payroll_id = cur_pay.payroll_id
4625: AND EXISTS (SELECT ''
4626: FROM pay_run_results prr,
4627: pay_element_types_f pet
4628: WHERE prr.assignment_action_id = prev_asg.assignment_action_id
4629: AND prr.element_type_id = pet.element_type_id
4630: AND pet.legislation_code ='IN'

Line 4729: pay_run_results prr,

4725: AND pact.action_type in('R','Q')
4726: AND prt.run_type_id = ASSACT.run_type_id
4727: AND prt.run_type_name ='Regular Run'
4728: AND EXISTS ( SELECT '1' FROM
4729: pay_run_results prr,
4730: pay_element_types_f pet
4731: WHERE prr.assignment_action_id = ASSACT.assignment_action_id
4732: AND prr.element_type_id = pet.element_type_id
4733: AND pet.legislation_code ='IN'