APPS.PAY_RETRO_NOTIF_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 308: FROM pay_element_types_f_tl petTL

304: l_element_name VARCHAR2(80) := NULL;
305: --
306: Cursor c_ins_upd_ele is
307: SELECT petTL.element_name element
308: FROM pay_element_types_f_tl petTL
309: , pay_element_types_f pet
310: , pay_element_links_f pel
311: , pay_element_entries_f pef
312: WHERE pef.element_entry_id = p_element_entry_id

Line 332: FROM pay_element_types_f_tl petTL

328: AND pet.effective_end_date;
329: --
330: Cursor c_del_ele is
331: SELECT petTL.element_name
332: FROM pay_element_types_f_tl petTL
333: , pay_element_types_f pet
334: , pay_run_results prr
335: WHERE prr.source_id = p_element_entry_id
336: AND prr.source_type = 'E'