[Home] [Help]
292: -- To find meaning for fnd_lookups code
293: IF (visit_rec.project_flag IS NOT NULL) THEN
294: SELECT meaning
295: INTO l_project_flag
296: FROM FND_LOOKUP_VALUES_VL
297: WHERE lookup_code = visit_rec.project_flag
298: AND LOOKUP_TYPE = 'AHL_YES_NO_TYPE';
299: END IF;
300: