DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_SETS

Line 1764: pay_element_sets pes

1760: union all
1761: select pes.element_set_id
1762: from pay_ele_classification_rules pecr,
1763: pay_element_types_f pet,
1764: pay_element_sets pes
1765: where pet.classification_id = pecr.classification_id
1766: and pes.element_set_id = pecr.element_set_id
1767: and (pes.business_group_id = pet.business_group_id
1768: or pet.legislation_code = cp_legislation_code)

Line 1987: pay_element_sets pes

1983: union all
1984: select pes.element_set_id
1985: from pay_ele_classification_rules pecr,
1986: pay_element_types_f pet,
1987: pay_element_sets pes
1988: where pet.classification_id = pecr.classification_id
1989: and pes.element_set_id = pecr.element_set_id
1990: and (pes.business_group_id = pet.business_group_id
1991: or pet.legislation_code = cp_legislation_code)