APPS.PAY_NO_EMP_CONT dependencies on PAY_ELEMENT_TYPES_F

Line 1443: FROM pay_element_types_f pet

1439: /* cursor to get the element_type_id of element 'Tax Deduction Base' */
1440:
1441: CURSOR csr_element_type (p_date_earned DATE ) IS
1442: SELECT ELEMENT_TYPE_ID
1443: FROM pay_element_types_f pet
1444: WHERE pet.element_name = 'Tax Deduction Base'
1445: AND pet.LEGISLATION_CODE = 'NO'
1446: AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
1447: