APPS.PAY_NO_ABSENCE dependencies on PER_ABS_ATTENDANCE_REASONS
Line 803: ,PER_ABS_ATTENDANCE_REASONS PAR
799: SELECT LKP.Meaning
800: INTO l_abs_reason
801: FROM FND_LOOKUP_VALUES LKP
802: ,PER_ABSENCE_ATTENDANCES PAA 803: ,PER_ABS_ATTENDANCE_REASONS PAR 804: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
805: AND PAA.ABS_ATTENDANCE_REASON_ID = PAR.ABS_ATTENDANCE_REASON_ID
806: AND PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id
807: AND LKP.lookup_type = 'ABSENCE_REASON'