DBA Data[Home] [Help]

APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_ELEMENT_SETS

Line 162: pay_element_sets pes

158: union all
159: select pes.element_set_id
160: from pay_ele_classification_rules pecr,
161: pay_element_types_f pet,
162: pay_element_sets pes
163: where pet.classification_id = pecr.classification_id
164: and pes.element_set_id = pecr.element_set_id
165: and (pes.business_group_id = pet.business_group_id
166: or pet.legislation_code = cp_legislation_code)

Line 283: pay_element_sets pes

279: union all
280: select pes.element_set_id
281: from pay_ele_classification_rules pecr,
282: pay_element_types_f pet,
283: pay_element_sets pes
284: where pet.classification_id = pecr.classification_id
285: and pes.element_set_id = pecr.element_set_id
286: and (pes.business_group_id = pet.business_group_id
287: or pet.legislation_code = cp_legislation_code)