DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PAY_RUN_RESULTS

Line 2019: pay_run_results prr,

2015: ,c_element_name IN VARCHAR2
2016: ,c_input_name IN VARCHAR2) IS
2017: SELECT prv.result_value
2018: FROM pay_run_result_values prv,
2019: pay_run_results prr,
2020: pay_input_values_f piv,
2021: pay_element_types_f pet
2022: WHERE prv.run_result_id = prr.run_result_id
2023: AND prr.assignment_action_id = c_assignment_action_id

Line 2266: FROM pay_run_results prr

2262: ,p_carry_over_id NUMBER
2263: ,p_exempted_id NUMBER)
2264: IS
2265: SELECT count(*)
2266: FROM pay_run_results prr
2267: ,pay_run_result_values prrv1
2268: ,pay_run_result_values prrv2
2269: ,pay_assignment_actions paa
2270: ,pay_payroll_actions ppa

Line 3573: FROM pay_run_results prr,

3569: AND prev_asg.action_sequence <= cur_asg.action_sequence
3570: AND cur_pay.effective_date between ptp.start_date and ptp.end_date
3571: AND ptp.payroll_id = cur_pay.payroll_id
3572: AND EXISTS (SELECT ''
3573: FROM pay_run_results prr,
3574: pay_element_types_f pet
3575: WHERE prr.assignment_action_id = prev_asg.assignment_action_id
3576: AND prr.element_type_id = pet.element_type_id
3577: AND pet.legislation_code ='IN'

Line 3676: pay_run_results prr,

3672: AND pact.action_type in('R','Q')
3673: AND prt.run_type_id = ASSACT.run_type_id
3674: AND prt.run_type_name ='Regular Run'
3675: AND EXISTS ( SELECT '1' FROM
3676: pay_run_results prr,
3677: pay_element_types_f pet
3678: WHERE prr.assignment_action_id = ASSACT.assignment_action_id
3679: AND prr.element_type_id = pet.element_type_id
3680: AND pet.legislation_code ='IN'