APPS.PAY_RETRO_NOTIF_PKG dependencies on PAY_ELEMENT_TYPES_F

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 309: , pay_element_types_f pet

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
313: AND pef.element_link_id = pel.element_link_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'

Line 333: , pay_element_types_f pet

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'
337: AND prr.element_type_id = pet.element_type_id

Line 417: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

413: and nvl(pee.creator_type, 'F') in ('EE', 'RR', 'PR', 'NR')
414: )
415: UNION
416: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
417: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
418: INDEX(PAF PER_ASSIGNMENTS_F_PK)
419: USE_NL(PDE PAF)*/
420: DISTINCT
421: pee.element_entry_id entry,

Line 543: , pay_element_types_f pet

539: nvl(pet.recalc_event_group_id, -1) event_group_id
540: FROM pay_assignment_actions paa
541: , pay_payroll_actions ppa
542: , pay_run_results prr
543: , pay_element_types_f pet
544: , pay_datetracked_events pde
545: WHERE prr.source_type = 'E'
546: AND prr.assignment_action_id = paa.assignment_action_id
547: AND prr.element_type_id = pet.element_type_id

Line 567: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

563: AND (ppa.date_earned BETWEEN cp_min_ed AND cp_max_ed
564: OR ppa.effective_date BETWEEN cp_min_ed AND cp_max_ed)
565: UNION
566: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
567: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
568: USE_NL(PDE PET)*/
569: DISTINCT
570: pee.element_entry_id entry,
571: pet.element_type_id type,

Line 575: , pay_element_types_f pet

571: pet.element_type_id type,
572: pde.datetracked_event_id,
573: nvl(pet.recalc_event_group_id, -1) event_group_id
574: FROM pay_element_entries_f pee
575: , pay_element_types_f pet
576: , pay_datetracked_events pde
577: WHERE pee.assignment_id = cp_asg
578: AND pee.element_type_id = pet.element_type_id
579: -- Only bring back a row if an event group is