DBA Data[Home] [Help]

APPS.PAY_US_RETRO_UPGRADE dependencies on PAY_ELEMENT_SETS

Line 177: pay_element_sets pes

173: union all
174: select pes.element_set_id
175: from pay_ele_classification_rules pecr,
176: pay_element_types_f pet,
177: pay_element_sets pes
178: where pet.classification_id = pecr.classification_id
179: and pes.element_set_id = pecr.element_set_id
180: and (pes.business_group_id = pet.business_group_id
181: or pet.legislation_code = cp_legislation_code)

Line 325: pay_element_sets pes

321: union all
322: select pes.element_set_id
323: from pay_ele_classification_rules pecr,
324: pay_element_types_f pet,
325: pay_element_sets pes
326: where pet.classification_id = pecr.classification_id
327: and pes.element_set_id = pecr.element_set_id
328: and (pes.business_group_id = pet.business_group_id
329: or pet.legislation_code = cp_legislation_code)