DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PER_ABS_ATTENDANCE_REASONS

Line 830: ,PER_ABS_ATTENDANCE_REASONS PAR

826: SELECT LKP.Meaning
827: INTO l_abs_reason
828: FROM FND_LOOKUP_VALUES LKP
829: ,PER_ABSENCE_ATTENDANCES PAA
830: ,PER_ABS_ATTENDANCE_REASONS PAR
831: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
832: AND PAA.ABS_ATTENDANCE_REASON_ID = PAR.ABS_ATTENDANCE_REASON_ID
833: AND PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id
834: AND LKP.lookup_type = 'ABSENCE_REASON'