eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 530: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

526: cp_min_ed DATE,
527: cp_max_ed DATE,
528: p_event_group_id number) is
529: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
530: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
531: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
532: USE_NL(PDE PET)*/
533: DISTINCT
534: prr.source_id entry,

Line 541: , pay_element_types_f pet

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

Line 565: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

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

Line 573: , pay_element_types_f pet

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