126: SELECT Meaning
127: INTO p_input_value5
128: FROM FND_LOOKUP_VALUES_VL LKP
129: ,PER_ABSENCE_ATTENDANCES PAA
130: ,PER_ABS_ATTENDANCE_REASONS PAR
131: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
132: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
133: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason
134: AND LKP.lookup_type = 'ABSENCE_REASON'
155: SELECT Meaning
156: INTO p_input_value5
157: FROM FND_LOOKUP_VALUES_VL LKP
158: ,PER_ABSENCE_ATTENDANCES PAA
159: ,PER_ABS_ATTENDANCE_REASONS PAR
160: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
161: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
162: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason
163: AND LKP.lookup_type = 'ABSENCE_REASON'
188: SELECT Meaning
189: INTO p_input_value5
190: FROM FND_LOOKUP_VALUES_VL LKP
191: ,PER_ABSENCE_ATTENDANCES PAA
192: ,PER_ABS_ATTENDANCE_REASONS PAR
193: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
194: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
195: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason
196: AND LKP.lookup_type = 'ABSENCE_REASON'