DBA Data[Home] [Help]

APPS.HR_AU_ABSENCE_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 13: l_processing_type pay_element_types_f.processing_type%TYPE;

9: l_proc varchar2(100) := 'hr_au_absence_hook.udpate_absence_dev_desc_flex';
10: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
11: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
12: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
13: l_processing_type pay_element_types_f.processing_type%TYPE;
14: l_ovn pay_element_entries_f.object_version_number%TYPE;
15: l_warning boolean;
16:
17: cursor c_get_absence_element (c_absence_attendance_id number)

Line 26: ,pay_element_types_f pet

22: ,pet.processing_type
23: ,max(pee.object_version_number)
24: from per_absence_attendances abs
25: ,pay_element_entries_f pee
26: ,pay_element_types_f pet
27: ,per_all_assignments_f paa
28: where abs.absence_attendance_id = c_absence_attendance_id
29: and pee.creator_id = abs.absence_attendance_id
30: and pee.creator_type = 'A'