APPS.PQP_GB_AD_EE dependencies on PAY_ELEMENT_LINKS_F

Line 140: FROM pay_element_links_f pel,

136: --
137:
138: SELECT count(asg.assignment_id)
139: INTO l_asg_count
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,

Line 233: FROM pay_element_links_f pel,

229: pet.element_type_id,
230: pel.element_link_id,
231: pel.effective_end_date link_end_date,
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

Line 258: FROM pay_element_links_f pel,

254: -- Cursor to check for Car and Mileage element entries
255:
256: CURSOR chk_cur IS
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

Line 283: FROM pay_element_links_f pel,

279: CURSOR scr_val_cur( p_name IN VARCHAR2
280: ,p_in_element_entry_id IN NUMBER
281: ) IS
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,

Line 316: FROM pay_element_links_f pel,

312:
313: CURSOR vehicle_type_cur(p_in_element_entry_id IN NUMBER
314: ) IS
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,

Line 353: FROM pay_element_links_f pel,

349: CURSOR scr_val_cur1( p_name IN VARCHAR2
350: ,p_in_element_entry_id IN NUMBER
351: ,p_in_end_date IN DATE) IS
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,

Line 386: FROM pay_element_links_f pel,

382:
383: CURSOR vehicle_type_cur1(p_in_element_entry_id IN NUMBER
384: ,p_in_end_date IN DATE) IS
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,

Line 745: pay_element_links_f link,

741: IS
742: SELECT element.element_type_id , link.element_link_id,element.business_group_id
743: FROM pay_element_types_f_tl elementtl,
744: pay_element_types_f element,
745: pay_element_links_f link,
746: per_all_assignments_f asgt ,
747: per_periods_of_service service_period
748: WHERE
749: --element.element_type_id = elementtl.element_type_id