DBA Data[Home] [Help]

APPS.HR_NZ_TAX_API dependencies on PAY_ELEMENT_TYPES_F

Line 61: FROM pay_element_types_f pet

57:
58: /*Bug 3648883: removed upper on element_name to improve performance*/
59: CURSOR csr_paye_tax_element(c_effective_date DATE) IS
60: SELECT pet.element_type_id
61: FROM pay_element_types_f pet
62: WHERE pet.element_name = 'PAYE Information'
63: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
64: AND legislation_code = 'NZ';
65: