DBA Data[Home] [Help]

APPS.HR_AU_ELEMENT_ENTRY_HOOK dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 41: l_absence_category per_absence_attendance_types.absence_category%type;

37: l_procedure_name varchar2(61) := 'hr_au_element_entry_hook.insert_absence_dev_desc_flex' ;
38: l_batch_id per_absence_attendances.batch_id%type ;
39: l_certificate_required pay_element_entry_values_f.screen_entry_value%type ;
40: l_certificate_received pay_element_entry_values_f.screen_entry_value%type ;
41: l_absence_category per_absence_attendance_types.absence_category%type;
42: l_element_name pay_element_types_f.element_name%type;
43:
44: -- cursor to get the batch ID for the absence
45:

Line 79: ,per_absence_attendance_types paa

75: from pay_element_entries_f pee
76: ,pay_element_links_f pef
77: ,pay_element_types_f pet
78: ,pay_input_values_F piv
79: ,per_absence_attendance_types paa
80: where pee.element_link_id = pef.element_link_id
81: and pef.element_type_id = pet.element_type_id
82: and pet.element_type_id = piv.element_type_id
83: and paa.input_value_id = piv.input_value_id