APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on FND_LOOKUP_VALUES_VL
Line 399: FROM FND_LOOKUP_VALUES_VL
395: as
396: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
397: IS
398: SELECT lookup_code 399: FROM FND_LOOKUP_VALUES_VL 400: WHERE lookup_type= c_lookup_type
401: AND upper(ltrim(rtrim(meaning)))=upper(ltrim(rtrim(c_meaning)))
402: AND sysdate between start_date_active
403: AND nvl(end_date_active,sysdate);