APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ABSENCE_ATTENDANCES

Line 153: FROM per_absence_attendances prev_abs

149: CURSOR csr_connected_absence IS
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')

Line 245: FROM per_absence_attendances abs

241: ) IS
242:
243: CURSOR csr_abs_overlap_another IS
244: SELECT 'Y'
245: FROM per_absence_attendances abs
246: WHERE abs.person_id = p_person_id
247: AND abs.date_start is not null
248: AND p_date_start is not null
249: AND (p_absence_attendance_id is null or

Line 457: FROM per_absence_attendances abs

453: CURSOR csr_cms_leave_taken ( p_personid NUMBER, p_start_date DATE, p_end_date DATE) IS
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'

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

Line 776: FROM PER_ABSENCE_ATTENDANCES

772:
773: CURSOR CSR_3SC_SICKNESS_CHECK(personid NUMBER, abs_start_date DATE, abs_link_period NUMBER) IS
774: SELECT DATE_START
775: ,DATE_END
776: FROM PER_ABSENCE_ATTENDANCES
777: WHERE PERSON_ID = personid
778: AND DATE_END BETWEEN (abs_start_date - abs_link_period) AND (abs_start_date -1)
779: AND ABS_INFORMATION1 = 'SC'
780: AND DATE_START IS NOT NULL

Line 788: FROM per_absence_attendances paa

784: CURSOR csr_absences_in_12months(c_person_id IN NUMBER
785: ,c_start_date IN DATE) IS
786: SELECT count (paa.absence_attendance_id) counts
787: ,sum ((paa.date_end - paa.date_start) + 1) days
788: FROM per_absence_attendances paa
789: WHERE paa.person_id = c_person_id
790: AND paa.date_end BETWEEN add_months (c_start_date,- 12)
791: AND (c_start_date - 1)
792: AND paa.abs_information1 = 'SC'

Line 948: FROM PER_ABSENCE_ATTENDANCES PAA

944: --Error - Only 4 self certificate absences are allowed for an year.
945: BEGIN
946: SELECT count(1)
947: INTO l_abs_count
948: FROM PER_ABSENCE_ATTENDANCES PAA
949: WHERE PAA.PERSON_ID = l_person_id
950: AND PAA.DATE_END BETWEEN add_months(l_abs_start_date, -12) AND (l_abs_start_date-1)
951: AND PAA.ABS_INFORMATION1 = 'SC'
952: AND PAA.DATE_START IS NOT NULL

Line 1152: FROM PER_ABSENCE_ATTENDANCES

1148:
1149: -- Get the person Id
1150: CURSOR get_person_id (p_abs_attendance_id in NUMBER) is
1151: SELECT person_id
1152: FROM PER_ABSENCE_ATTENDANCES
1153: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
1154:
1155: l_person_id NUMBER;
1156: BEGIN