APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

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

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

Line 6857: from per_absence_attendance_types aat

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