DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 45: l_tax_code pay_run_result_values.result_value%type;

41: --
42:
43: function get_tax_code (p_run_assignment_action_id number) return varchar2 is
44:
45: l_tax_code pay_run_result_values.result_value%type;
46: l_special_tax_code pay_run_result_values.result_value%type;
47:
48: --
49: -- Fetch Special Tax Code along with Tax Code (Bug No : 1817816)

Line 46: l_special_tax_code pay_run_result_values.result_value%type;

42:
43: function get_tax_code (p_run_assignment_action_id number) return varchar2 is
44:
45: l_tax_code pay_run_result_values.result_value%type;
46: l_special_tax_code pay_run_result_values.result_value%type;
47:
48: --
49: -- Fetch Special Tax Code along with Tax Code (Bug No : 1817816)
50: --

Line 55: , pay_run_result_values rrv

51: cursor c_tax_code (p_assignment_action_id number) is
52: select rrv.result_value,rrv1.result_value
53: from pay_element_types_f et
54: , pay_input_values_f iv
55: , pay_run_result_values rrv
56: , pay_run_results rr
57: , pay_input_values_f iv1
58: , pay_run_result_values rrv1
59: , pay_payroll_actions ppa

Line 58: , pay_run_result_values rrv1

54: , pay_input_values_f iv
55: , pay_run_result_values rrv
56: , pay_run_results rr
57: , pay_input_values_f iv1
58: , pay_run_result_values rrv1
59: , pay_payroll_actions ppa
60: , pay_assignment_actions paa
61: where et.element_name = 'PAYE Information'
62: and et.legislation_code = 'NZ'