DBA Data[Home] [Help]

APPS.HR_NZ_TAX_API dependencies on PAY_INPUT_VALUES_F

Line 67: CURSOR csr_paye_tax_input_values(c_element_type_id pay_input_values_f.element_type_id%TYPE

63: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
64: AND legislation_code = 'NZ';
65:
66:
67: CURSOR csr_paye_tax_input_values(c_element_type_id pay_input_values_f.element_type_id%TYPE
68: ,c_effective_date DATE) IS
69: SELECT piv.input_value_id
70: ,piv.name
71: FROM pay_input_values_f piv

Line 71: FROM pay_input_values_f piv

67: CURSOR csr_paye_tax_input_values(c_element_type_id pay_input_values_f.element_type_id%TYPE
68: ,c_effective_date DATE) IS
69: SELECT piv.input_value_id
70: ,piv.name
71: FROM pay_input_values_f piv
72: WHERE piv.element_type_id = c_element_type_id
73: AND c_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
74:
75: