DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_SETS

Line 1555: pay_element_sets pes

1551: union all
1552: select pes.element_set_id
1553: from pay_ele_classification_rules pecr,
1554: pay_element_types_f pet,
1555: pay_element_sets pes
1556: where pet.classification_id = pecr.classification_id
1557: and pes.element_set_id = pecr.element_set_id
1558: and (pes.business_group_id = pet.business_group_id
1559: or pet.legislation_code = cp_legislation_code)

Line 1784: pay_element_sets pes

1780: union all
1781: select pes.element_set_id
1782: from pay_ele_classification_rules pecr,
1783: pay_element_types_f pet,
1784: pay_element_sets pes
1785: where pet.classification_id = pecr.classification_id
1786: and pes.element_set_id = pecr.element_set_id
1787: and (pes.business_group_id = pet.business_group_id
1788: or pet.legislation_code = cp_legislation_code)