DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_ELEMENT_TYPES_F

Line 1547: FROM pay_element_types_f pet

1543:
1544: /*
1545: CURSOR csr_element_type (p_date_earned DATE ) IS
1546: SELECT ELEMENT_TYPE_ID
1547: FROM pay_element_types_f pet
1548: WHERE pet.element_name = 'Tax Deduction Base'
1549: AND pet.LEGISLATION_CODE = 'NO'
1550: AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
1551: */

Line 1557: FROM pay_element_types_f pet

1553: -- changing element from Tax Deduction Base to Tax
1554:
1555: CURSOR csr_element_type (p_date_earned DATE ) IS
1556: SELECT ELEMENT_TYPE_ID
1557: FROM pay_element_types_f pet
1558: WHERE pet.element_name = 'Tax'
1559: AND pet.LEGISLATION_CODE = 'NO'
1560: AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
1561: