APPS.PAY_GB_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 156: from pay_element_types_f pet, pay_element_classifications pec

152: ,p_qualified out nocopy varchar2)
153: IS
154: cursor c_element_class(cp_element_type_id in number) is
155: select pet.classification_id, pet.element_name, pet.legislation_code, pet.business_group_id, pec.classification_name
156: from pay_element_types_f pet, pay_element_classifications pec
157: where pet.element_type_id = cp_element_type_id
158: and pet.classification_id = pec.classification_id;
159:
160: cursor c_legislation_code(cp_business_group_id in number) is

Line 175: pay_element_types_f pet,

171: and petr.include_or_exclude = 'I'
172: union all
173: select pes.element_set_id
174: from pay_ele_classification_rules pecr,
175: pay_element_types_f pet,
176: pay_element_sets pes
177: where pet.classification_id = pecr.classification_id
178: and pes.element_set_id = pecr.element_set_id
179: and (pes.business_group_id = pet.business_group_id

Line 346: from pay_element_types_f pet

342: cursor c_element_dtl(cp_element_type_id in number) is
343: select business_group_id, legislation_code, classification_id,
344: nvl(retro_summ_ele_id, pet.element_type_id),
345: element_name
346: from pay_element_types_f pet
347: where pet.element_type_id = cp_element_type_id
348: order by pet.effective_start_date desc;
349:
350: cursor c_legislation_code(cp_business_group_id in number) is

Line 365: pay_element_types_f pet,

361: and petr.include_or_exclude = 'I'
362: union all
363: select pes.element_set_id
364: from pay_ele_classification_rules pecr,
365: pay_element_types_f pet,
366: pay_element_sets pes
367: where pet.classification_id = pecr.classification_id
368: and pes.element_set_id = pecr.element_set_id
369: and (pes.business_group_id = pet.business_group_id