DBA Data[Home] [Help]

APPS.HXC_ABS_RETRIEVAL_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 2482: FROM pay_element_entries_f peef, pay_element_links_f pelf

2478: SELECT peef.element_entry_id, peef.effective_start_date,
2479: peef.effective_end_date,
2480: peef.object_version_number,
2481: pelf.costable_type
2482: FROM pay_element_entries_f peef, pay_element_links_f pelf
2483: WHERE peef.creator_id = p_absence_attendance_id
2484: AND peef.element_link_id = pelf.element_link_id
2485: AND peef.object_version_number =
2486: (SELECT /*+NO_UNNEST*/

Line 2488: FROM pay_element_entries_f

2484: AND peef.element_link_id = pelf.element_link_id
2485: AND peef.object_version_number =
2486: (SELECT /*+NO_UNNEST*/
2487: MAX (object_version_number)
2488: FROM pay_element_entries_f
2489: WHERE creator_id = p_absence_attendance_id);
2490:
2491: l_element_entry_id NUMBER;
2492: l_effective_start_date DATE;