DBA Data[Home] [Help]

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'