DBA Data[Home] [Help]

APPS.PAY_US_GARN_UPGRADE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1448: pay_element_classifications pec

1444: cp_mig_date date) IS
1445: select /*+ Choose */
1446: 'Upgrade'
1447: from pay_element_types_f petf,
1448: pay_element_classifications pec
1449: where petf.element_type_id = cp_ele_type_id
1450: and petf.legislation_code is NULL
1451: and petf.effective_end_date > cp_mig_date
1452: and pec.classification_id = petf.classification_id