DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on PER_ABS_ATTENDANCE_REASONS

Line 89: ,per_abs_attendance_reasons rea

85: CURSOR csr_abs_rea(p_absence_attendance_id IN NUMBER)
86: IS
87: SELECT lkp.meaning
88: FROM per_absence_attendances ABS
89: ,per_abs_attendance_reasons rea
90: ,hr_lookups lkp
91: WHERE ABS.abs_attendance_reason_id = rea.abs_attendance_reason_id
92: AND rea.NAME = lkp.lookup_code
93: AND lookup_type = 'ABSENCE_REASON'