DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_ELEMENT_TYPES_F

Line 1310: FROM pay_element_types_f pet

1306:
1307: /*
1308: CURSOR csr_element_type (p_date_earned DATE ) IS
1309: SELECT ELEMENT_TYPE_ID
1310: FROM pay_element_types_f pet
1311: WHERE pet.element_name = 'Tax Deduction Base'
1312: AND pet.LEGISLATION_CODE = 'NO'
1313: AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
1314: */

Line 1320: FROM pay_element_types_f pet

1316: -- changing element from Tax Deduction Base to Tax
1317:
1318: CURSOR csr_element_type (p_date_earned DATE ) IS
1319: SELECT ELEMENT_TYPE_ID
1320: FROM pay_element_types_f pet
1321: WHERE pet.element_name = 'Tax'
1322: AND pet.LEGISLATION_CODE = 'NO'
1323: AND p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;
1324: