DBA Data[Home] [Help]

APPS.PER_NL_ABSENCE_TRACK_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 199: per_absence_attendance_types atyp

195: select abs.absence_attendance_id,abs.business_group_id,
196: abs.absence_attendance_type_id,atyp.absence_category,
197: nvl(abs.date_start,abs.date_projected_start) start_date
198: from per_absence_attendances abs,
199: per_absence_attendance_types atyp
200: where absence_attendance_id =p_absence_attendance_id
201: and abs.absence_attendance_type_id= atyp.absence_attendance_type_id;
202:
203: vc_abs_cat c_abs_cat%ROWTYPE;