21406: END IF;
21407:
21408: SELECT 'VALID'
21409: INTO l_dummy 21410: FROM MFG_LOOKUPS 21411: WHERE LOOKUP_CODE = p_Item_Relationship_Type
21412: AND LOOKUP_TYPE = l_lookup_type
21413: AND ENABLED_FLAG = 'Y'
21414: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)