330: --
331: -- Variables for IN/OUT parameters
332: l_object_version_number number;
333:
334: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
335: l_business_group_id per_absence_attendances.business_group_id%type;
336:
337: Cursor c_is_gb_leg is
338: select absence_attendance_type_id, business_group_id
331: -- Variables for IN/OUT parameters
332: l_object_version_number number;
333:
334: l_absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%type;
335: l_business_group_id per_absence_attendances.business_group_id%type;
336:
337: Cursor c_is_gb_leg is
338: select absence_attendance_type_id, business_group_id
339: from per_absence_attendances
335: l_business_group_id per_absence_attendances.business_group_id%type;
336:
337: Cursor c_is_gb_leg is
338: select absence_attendance_type_id, business_group_id
339: from per_absence_attendances
340: where absence_attendance_id = p_absence_attendance_id;
341:
342: --
343: -- Other variables
666: lv_action varchar2(30);
667:
668: Cursor c_get_dur(p_absence_attendance_id number) is
669: select absence_days, absence_hours
670: from per_absence_attendances
671: where absence_attendance_id = p_absence_attendance_id;
672:
673:
674: BEGIN