APPS.HR_AU_ABSENCE_HOOK dependencies on PAY_ELEMENT_ENTRIES_F

Line 10: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

6: PROCEDURE UPDATE_ABSENCE_DEV_DESC_FLEX ( p_absence_attendance_id IN NUMBER
7: ) AS
8:
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;

Line 11: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

7: ) AS
8:
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;

Line 12: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

8:
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:

Line 14: l_ovn pay_element_entries_f.object_version_number%TYPE;

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)
18: is

Line 25: ,pay_element_entries_f pee

21: ,pee.effective_end_date
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