DBA Data[Home] [Help]

APPS.PAY_PAYRPENP_XML_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 235: per_absence_attendance_types typ

231:
232: cursor c_absence(c_person_id number,c_period_end_date date, c_period_start_date date) is
233: select typ.name
234: from per_absence_attendances att,
235: per_absence_attendance_types typ
236: where att.person_id = c_person_id
237: and att.absence_attendance_type_id = typ.absence_attendance_type_id
238: and att.date_start <= c_period_end_date
239: and att.date_end >= c_period_start_date;