APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ABS_ATTENDANCE_REASONS

Line 770: select name from PER_ABS_ATTENDANCE_REASONS par

766: AND PAA.PERSON_ID = personid
767: ORDER BY DATE_START ;
768:
769: CURSOR CSR_REASON_CODE ( attn_reason_id NUMBER) IS
770: select name from PER_ABS_ATTENDANCE_REASONS par
771: WHERE PAR.ABS_ATTENDANCE_REASON_ID = attn_reason_id ;
772:
773: CURSOR CSR_3SC_SICKNESS_CHECK(personid NUMBER, abs_start_date DATE, abs_link_period NUMBER) IS
774: SELECT DATE_START