APPS.PAY_TEMPLATE_IVS dependencies on PAY_ELEMENT_ENTRIES_F

Line 145: FROM pay_element_entries_f pee

141: 2a. For each link row found in 1a, need to find date-effective
142: Element Entries that exist for the element link:
143: SELECT DISTINCT pee.element_entry_id
144: INTO l_element_entry_id
145: FROM pay_element_entries_f pee
146: WHERE pee.element_link_id = l_element_link_id -- ie. link found in 1a.
147: ORDER BY pee.element_entry_id;
148:
149:

Line 236: FROM pay_element_entries_f pee

232: ORDER BY pel.effective_start_date;
233:
234: CURSOR get_entries (p_link_id NUMBER) IS
235: SELECT pee.element_entry_id
236: FROM pay_element_entries_f pee
237: WHERE pee.element_link_id = p_link_id
238: ORDER BY pee.element_entry_id;
239:
240: CURSOR get_entry_values (p_entry_id NUMBER) IS

Line 681: pay_element_entries_f ee

677: from sys.dual
678: where exists
679: (select 1
680: from pay_element_links_f el,
681: pay_element_entries_f ee
682: where p_element_type_id = el.element_type_id
683: and el.element_link_id = ee.element_link_id
684: and ee.effective_end_date >= p_val_start_date
685: and ee.effective_start_date <= p_val_end_date);