DBA Data[Home] [Help]

APPS.PAY_IN_TAX_UTILS dependencies on PAY_RUN_RESULT_VALUES

Line 2429: FROM pay_run_result_values prv,

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

Line 2703: ,pay_run_result_values prrv1

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

Line 2704: ,pay_run_result_values prrv2

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