DBA Data[Home] [Help]

APPS.HR_NZ_ELEMENT_ENTRY_HOOK dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 40: l_absence_category per_absence_attendance_types.absence_category%type;

36: l_procedure_name varchar2(61) := 'hr_nz_element_entry_hook.populate_absence_dev_desc_flex' ;
37: l_batch_id per_absence_attendances.batch_id%type ;
38: l_seasonal_shutdown pay_element_entry_values_f.screen_entry_value%type ;
39: l_number_of_complete_weeks pay_element_entry_values_f.screen_entry_value%type ;
40: l_absence_category per_absence_attendance_types.absence_category%type;
41: l_element_name pay_element_types_f.element_name%type;
42:
43: -- cursor to get the batch ID for the absence
44: cursor c_absence (p_absence_attendance_id number) is

Line 75: , per_absence_attendance_types paa

71: pay_element_entries_f pee
72: , pay_element_links_f pef
73: , pay_element_types_f pet
74: , pay_input_values_F piv
75: , per_absence_attendance_types paa
76: where pee.element_link_id= pef.element_link_id
77: and pef.element_type_id = pet.element_type_id
78: and pet.element_type_id = piv.element_type_id
79: and paa.input_value_id = piv.input_value_id