APPS.HR_NZ_ELEMENT_ENTRY_HOOK dependencies on PER_ABSENCE_ATTENDANCES

Line 37: l_batch_id per_absence_attendances.batch_id%type ;

33: ,p_element_link_id in number
34: ,p_creator_id in number) is
35:
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;

Line 46: from per_absence_attendances aa

42:
43: -- cursor to get the batch ID for the absence
44: cursor c_absence (p_absence_attendance_id number) is
45: select aa.batch_id
46: from per_absence_attendances aa
47: where aa.absence_attendance_id = p_absence_attendance_id ;
48:
49: -- cursor to get input value
50: cursor c_input_value (p_element_entry_id number

Line 154: update per_absence_attendances

150: end if ;
151:
152: close c_input_value ;
153:
154: update per_absence_attendances
155: set abs_information1 = l_seasonal_shutdown
156: , abs_information_category = 'NZ_' || l_absence_category
157: where absence_attendance_id = p_creator_id ;
158:

Line 179: update per_absence_attendances

175:
176: close c_input_value ;
177:
178: -- now update the DF segments
179: update per_absence_attendances
180: set abs_information_category = 'NZ_' || l_absence_category
181: , abs_information2 = l_number_of_complete_weeks
182: where absence_attendance_id = p_creator_id ;
183: