APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 331: per_absence_attendance_types paat

327: --
328: cursor cur_per_abs_s_chags is
329: select paat.absence_category
330: from per_absence_attendances paa,
331: per_absence_attendance_types paat
332: where paa.absence_attendance_type_id
333: = paat.absence_attendance_type_id
334: and paa.absence_attendance_id = p_absence_attendance_id
335: and paa.business_group_id = paat.business_group_id;

Line 337: v_per_abs_chgs per_absence_attendance_types.absence_category%TYPE;

333: = paat.absence_attendance_type_id
334: and paa.absence_attendance_id = p_absence_attendance_id
335: and paa.business_group_id = paat.business_group_id;
336: --
337: v_per_abs_chgs per_absence_attendance_types.absence_category%TYPE;
338: --
339: BEGIN
340: --
341: open cur_per_abs_s_chags;