APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 154: ,per_absence_attendance_types pat

150: SELECT p_conn_start_date - prev_abs.date_end duration
151: ,prev_abs.date_start start_date
152: ,prev_abs.date_end end_date
153: FROM per_absence_attendances prev_abs
154: ,per_absence_attendance_types pat
155: WHERE prev_abs.absence_attendance_type_id = pat.absence_attendance_type_id
156: AND prev_abs.date_end < p_conn_start_date
157: AND pat.absence_category IN ('S','PTS')
158: AND (((p_conn_start_date - prev_abs.date_end) <= p_abs_link_period)

Line 458: ,per_absence_attendance_types paat

454: SELECT abs.date_start
455: ,abs.date_end
456: ,abs.absence_days
457: FROM per_absence_attendances abs
458: ,per_absence_attendance_types paat
459: WHERE abs.person_id = p_person_id
460: AND abs.absence_attendance_type_id = paat.absence_attendance_type_id
461: AND paat.absence_category = 'CMS'
462: AND abs.absence_attendance_id <> NVL(l_glb_absence_attendance_id,-1)

Line 761: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

757: AND EFFECTIVE_END_DATE;
758:
759: CURSOR CSR_SICKNESS_ELIG_CHECK (personid NUMBER) IS
760: SELECT (PAA.DATE_END - PAA.DATE_START) + 1 AS DAYS,PAA.DATE_START, PAA.DATE_END
761: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
762: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
763: AND PAT.ABSENCE_CATEGORY = 'UN'
764: AND PAA.DATE_START IS NOT NULL
765: AND PAA.DATE_END IS NOT NULL