DBA Data[Home] [Help]

APPS.PAY_US_GARN_UPGRADE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1463: pay_element_classifications pec

1459: cp_mig_date date) IS
1460: select /*+ Choose */
1461: 'Upgrade'
1462: from pay_element_types_f petf,
1463: pay_element_classifications pec
1464: where petf.element_type_id = cp_ele_type_id
1465: and petf.legislation_code is NULL
1466: and petf.effective_end_date > cp_mig_date
1467: and pec.classification_id = petf.classification_id