APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 143: from pay_element_types_f

139: ,p_qualified out nocopy varchar2)
140: IS
141: cursor c_element_class(cp_element_type_id in number) is
142: select classification_id, element_name, legislation_code, business_group_id
143: from pay_element_types_f
144: where element_type_id = cp_element_type_id;
145:
146: cursor c_legislation_code(cp_business_group_id in number) is
147: select legislation_code

Line 161: pay_element_types_f pet,

157: and petr.include_or_exclude = 'I'
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

Line 263: from pay_element_types_f pet

259: cursor c_element_dtl(cp_element_type_id in number) is
260: select business_group_id, legislation_code, classification_id,
261: nvl(retro_summ_ele_id, pet.element_type_id),
262: element_name
263: from pay_element_types_f pet
264: where pet.element_type_id = cp_element_type_id
265: order by pet.effective_start_date desc;
266:
267: cursor c_legislation_code(cp_business_group_id in number) is

Line 282: pay_element_types_f pet,

278: and petr.include_or_exclude = 'I'
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