APPS.PAY_US_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPES_F

Line 158: from pay_element_types_f

154: ,p_qualified out nocopy varchar2)
155: IS
156: cursor c_element_class(cp_element_type_id in number) is
157: select classification_id, element_name, legislation_code, business_group_id
158: from pay_element_types_f
159: where element_type_id = cp_element_type_id;
160:
161: cursor c_legislation_code(cp_business_group_id in number) is
162: select legislation_code

Line 176: pay_element_types_f pet,

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

Line 305: from pay_element_types_f pet

301: cursor c_element_dtl(cp_element_type_id in number) is
302: select business_group_id, legislation_code, classification_id,
303: nvl(retro_summ_ele_id, pet.element_type_id),
304: element_name
305: from pay_element_types_f pet
306: where pet.element_type_id = cp_element_type_id
307: order by pet.effective_start_date desc;
308:
309: cursor c_legislation_code(cp_business_group_id in number) is

Line 324: pay_element_types_f pet,

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