APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 175: ,pay_element_types_f pet

171: AND creator_type = 'ET'
172: AND creator_id = pet.element_type_id
173: ) py_cy_adj_retro_element_id
174: FROM pay_element_type_extra_info pei
175: ,pay_element_types_f pet
176: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
177: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
178: AND c_effective_date BETWEEN pet.effective_start_date
179: AND pet.effective_end_date

Line 200: pay_element_types_f pet,

196: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) contr_amt
197: ,pty.ee_contribution_bal_type_id
198: ,pty.er_contribution_bal_type_id
199: FROM pay_element_type_extra_info pei,
200: pay_element_types_f pet,
201: pay_element_entries_f peef,
202: pay_element_links_f pelf,
203: pay_element_entry_values_f peev,
204: pay_input_values_f pivf,

Line 238: FROM pay_element_types_f pet1

234: AND component_name = 'Adjustment')
235: AND creator_type = 'ET'
236: AND (creator_id = pei.element_type_id OR
237: creator_id IN (SELECT element_type_id
238: FROM pay_element_types_f pet1
239: WHERE pet1.element_name = pei.eei_information9 || ' ABP Employer Pension Contribution'
240: AND pet1.business_group_id = pet.business_group_id))) )
241: AND pelf.element_type_id = pet.element_type_id
242: AND pivf.element_type_id = pet.element_type_id

Line 1150: ,pay_element_types_f pet

1146: ,piv1.input_value_id end_dt_id
1147: ,pet.element_type_id
1148: FROM pay_input_values_f piv
1149: ,pay_input_values_f piv1
1150: ,pay_element_types_f pet
1151: WHERE piv.name = 'Start Date'
1152: AND piv.element_type_id = pet.element_type_id
1153: AND piv1.name = 'End Date'
1154: AND piv1.element_type_id = pet.element_type_id

Line 1238: ,pay_element_types_f pet

1234: ,c_input_value_name IN VARCHAR2) IS
1235: SELECT piv.input_value_id
1236: ,pet.element_type_id
1237: FROM pay_input_values_f piv
1238: ,pay_element_types_f pet
1239: WHERE piv.name = c_input_value_name
1240: AND piv.element_type_id = pet.element_type_id
1241: AND pet.element_name = c_element_name;
1242: --=========================================================================

Line 2499: FROM pay_element_types_f petf

2495: )
2496: AND EXISTS
2497: (
2498: SELECT 1
2499: FROM pay_element_types_f petf
2500: WHERE peef.element_type_id = petf.element_type_id
2501: AND upper (element_name) LIKE '%RETRO%ABP%'
2502: AND (
2503: c_start_date BETWEEN petf.effective_start_date