APPS.PAY_GB_ENH_RETRO_PAY dependencies on PAY_ELEMENT_TYPES_F

Line 13: pay_element_types_f pet,

9: IS
10: SELECT DISTINCT
11: pet.element_type_id
12: FROM
13: pay_element_types_f pet,
14: per_business_groups_perf pbg1,
15: per_business_groups_perf pbg
16: WHERE
17: pbg1.legislation_code = pbg.legislation_code

Line 52: l_element_type_id pay_element_types_f.element_type_id%TYPE;

48: pay_upgrade_definitions
49: WHERE
50: legislation_code='GB'
51: AND short_name ='GB_ENHANCED_RETROPAY';
52: l_element_type_id pay_element_types_f.element_type_id%TYPE;
53: l_element_validity BOOLEAN;
54: l_completion_status pay_upgrade_status.STATUS%TYPE;
55: l_definition_id pay_upgrade_definitions.UPGRADE_DEFINITION_ID%TYPE;
56: BEGIN

Line 134: pay_element_types_f pet,

130: pet.legislation_code,
131: pet.business_group_id,
132: pec.classification_name
133: FROM
134: pay_element_types_f pet,
135: pay_element_classifications pec
136: WHERE
137: pet.element_type_id = cp_element_type_id
138: AND pet.classification_id = pec.classification_id;

Line 162: pay_element_types_f pet,

158: SELECT
159: pes.element_set_id
160: FROM
161: pay_ele_classification_rules pecr,
162: pay_element_types_f pet,
163: pay_element_sets pes
164: WHERE
165: pet.classification_id = pecr.classification_id
166: AND pes.element_set_id = pecr.element_set_id

Line 277: pay_element_types_f pet

273: classification_id,
274: NVL(retro_summ_ele_id, pet.element_type_id),
275: element_name
276: FROM
277: pay_element_types_f pet
278: WHERE
279: pet.element_type_id = cp_element_type_id
280: ORDER BY
281: pet.effective_start_date DESC;

Line 317: pay_element_types_f pet,

313: SELECT
314: pes.element_set_id
315: FROM
316: pay_ele_classification_rules pecr,
317: pay_element_types_f pet,
318: pay_element_sets pes
319: WHERE
320: pet.classification_id = pecr.classification_id
321: AND pes.element_set_id = pecr.element_set_id