APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ABSENCE_ATTENDANCES

Line 41: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

37: AND EFFECTIVE_END_DATE;
38:
39: CURSOR CSR_SICKNESS_ELIG_CHECK (personid NUMBER) IS
40: SELECT (PAA.DATE_END - PAA.DATE_START) + 1 AS DAYS,PAA.DATE_START, PAA.DATE_END
41: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
42: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
43: AND PAT.ABSENCE_CATEGORY = 'UN'
44: AND PAA.DATE_START IS NOT NULL
45: AND PAA.DATE_END IS NOT NULL

Line 56: FROM PER_ABSENCE_ATTENDANCES

52:
53: CURSOR CSR_3SC_SICKNESS_CHECK(personid NUMBER, abs_start_date DATE, abs_link_period NUMBER) IS
54: SELECT DATE_START
55: ,DATE_END
56: FROM PER_ABSENCE_ATTENDANCES
57: WHERE PERSON_ID = personid
58: AND DATE_END BETWEEN (abs_start_date - abs_link_period) AND (abs_start_date -1)
59: AND ABS_INFORMATION1 = 'SC'
60: AND DATE_START IS NOT NULL

Line 190: FROM PER_ABSENCE_ATTENDANCES PAA

186: --Error - Only 4 self certificate absences are allowed for an year.
187: BEGIN
188: SELECT count(1)
189: INTO l_abs_count
190: FROM PER_ABSENCE_ATTENDANCES PAA
191: WHERE PAA.PERSON_ID = l_person_id
192: AND PAA.DATE_END BETWEEN add_months(l_abs_start_date, -12) AND (l_abs_start_date-1)
193: AND PAA.ABS_INFORMATION1 = 'SC'
194: AND PAA.DATE_START IS NOT NULL

Line 300: FROM PER_ABSENCE_ATTENDANCES

296:
297: -- Get the person Id
298: CURSOR get_person_id (p_abs_attendance_id in NUMBER) is
299: SELECT person_id
300: FROM PER_ABSENCE_ATTENDANCES
301: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
302:
303: l_person_id NUMBER;
304: BEGIN