APPS.PQP_GB_AD_EE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 144: pay_element_type_extra_info pete,

140: FROM pay_element_links_f pel,
141: pay_element_entries_f pee,
142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,
146: pay_input_values_f piv
147: WHERE pet.element_type_id = pel.element_type_id
148: AND pel.element_link_id = pee.element_link_id

Line 236: pay_element_type_extra_info pete

232: pee.effective_start_date
233: FROM pay_element_links_f pel,
234: pay_element_entries_f pee,
235: pay_element_types_f pet,
236: pay_element_type_extra_info pete
237: WHERE pet.element_type_id = pel.element_type_id
238: AND pel.element_link_id = pee.element_link_id
239: AND pet.element_type_id = pete.element_type_id
240: AND p_effective_date BETWEEN

Line 261: pay_element_type_extra_info pete

257: SELECT 'x'
258: FROM pay_element_links_f pel,
259: pay_element_entries_f pee,
260: pay_element_types_f pet,
261: pay_element_type_extra_info pete
262: WHERE pet.element_type_id = pel.element_type_id
263: AND pel.element_link_id = pee.element_link_id
264: AND pet.element_type_id = pete.element_type_id
265: AND pee.assignment_id = p_assignment_id_o

Line 286: pay_element_type_extra_info pete,

282: SELECT peev.screen_entry_value
283: FROM pay_element_links_f pel,
284: pay_element_entries_f pee,
285: pay_element_types_f pet,
286: pay_element_type_extra_info pete,
287: pay_element_entry_values_f peev,
288: pay_input_values_f piv
289: WHERE pet.element_type_id = pel.element_type_id
290: AND pel.element_link_id = pee.element_link_id

Line 319: pay_element_type_extra_info pete,

315: SELECT peev.screen_entry_value
316: FROM pay_element_links_f pel,
317: pay_element_entries_f pee,
318: pay_element_types_f pet,
319: pay_element_type_extra_info pete,
320: pay_element_entry_values_f peev,
321: pay_input_values_f piv
322: WHERE pet.element_type_id = pel.element_type_id
323: AND pel.element_link_id = pee.element_link_id

Line 356: pay_element_type_extra_info pete,

352: SELECT peev.screen_entry_value
353: FROM pay_element_links_f pel,
354: pay_element_entries_f pee,
355: pay_element_types_f pet,
356: pay_element_type_extra_info pete,
357: pay_element_entry_values_f peev,
358: pay_input_values_f piv
359: WHERE pet.element_type_id = pel.element_type_id
360: AND pel.element_link_id = pee.element_link_id

Line 389: pay_element_type_extra_info pete,

385: SELECT peev.screen_entry_value
386: FROM pay_element_links_f pel,
387: pay_element_entries_f pee,
388: pay_element_types_f pet,
389: pay_element_type_extra_info pete,
390: pay_element_entry_values_f peev,
391: pay_input_values_f piv
392: WHERE pet.element_type_id = pel.element_type_id
393: AND pel.element_link_id = pee.element_link_id

Line 710: FROM pay_element_type_extra_info pete

706: l_proc varchar2(72) := g_package||'create_term_ele_entries';
707: CURSOR c_ele_type (cp_element_type_id NUMBER)
708: IS
709: SELECT pete.eei_information1 ele_type
710: FROM pay_element_type_extra_info pete
711: WHERE pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
712: AND pete.element_type_id= cp_element_type_id;
713:
714: