APPS.PAY_NO_ABS_VALIDATION dependencies on PER_ABS_ATTENDANCE_REASONS

Line 50: select name from PER_ABS_ATTENDANCE_REASONS par

46: AND PAA.PERSON_ID = personid
47: ORDER BY DATE_START ;
48:
49: CURSOR CSR_REASON_CODE ( attn_reason_id NUMBER) IS
50: select name from PER_ABS_ATTENDANCE_REASONS par
51: WHERE PAR.ABS_ATTENDANCE_REASON_ID = attn_reason_id ;
52:
53: CURSOR CSR_3SC_SICKNESS_CHECK(personid NUMBER, abs_start_date DATE, abs_link_period NUMBER) IS
54: SELECT DATE_START