DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PAY_RUN_RESULT_VALUES

Line 2018: FROM pay_run_result_values prv,

2014: CURSOR c_claim_80gg_flag(c_assignment_action_id NUMBER
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

Line 2267: ,pay_run_result_values prrv1

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
2271: where prr.run_result_id =prrv1.run_result_id

Line 2268: ,pay_run_result_values prrv2

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
2271: where prr.run_result_id =prrv1.run_result_id
2272: and prrv1.input_value_id = p_exempted_id