APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 6852: l_absence_type_name per_absence_attendance_types.name%type := null;

6848: (
6849: p_absence_attendance_type_id in number
6850: ) return varchar2 is
6851:
6852: l_absence_type_name per_absence_attendance_types.name%type := null;
6853:
6854: cursor c_absence_type_name is
6855: select aat.name
6856: from per_absence_attendance_types aat

Line 6856: from per_absence_attendance_types aat

6852: l_absence_type_name per_absence_attendance_types.name%type := null;
6853:
6854: cursor c_absence_type_name is
6855: select aat.name
6856: from per_absence_attendance_types aat
6857: where aat.absence_attendance_type_id = p_absence_attendance_type_id;
6858:
6859: begin
6860: open c_absence_type_name;