APPS.PQP_GB_OSP_FUNCTIONS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 68: FROM per_absence_attendances ABS, per_absence_attendance_types TYPE

64: -- Cursor to get Absence Type for a Absence Id.
65: CURSOR csr_abs_type(p_absence_attendance_id IN NUMBER)
66: IS
67: SELECT TYPE.NAME
68: FROM per_absence_attendances ABS, per_absence_attendance_types TYPE
69: WHERE ABS.absence_attendance_type_id = TYPE.absence_attendance_type_id
70: AND ABS.absence_attendance_id = p_absence_attendance_id;
71:
72: -- Cursor to get absence Category for a Absence Id.

Line 77: ,per_absence_attendance_types TYPE

73: CURSOR csr_abs_cat(p_absence_attendance_id IN NUMBER)
74: IS
75: SELECT lkp.meaning
76: FROM per_absence_attendances ABS
77: ,per_absence_attendance_types TYPE
78: ,hr_lookups lkp
79: WHERE ABS.absence_attendance_type_id = TYPE.absence_attendance_type_id
80: AND TYPE.absence_category = lkp.lookup_code
81: AND lkp.lookup_type = 'ABSENCE_CATEGORY'