594: p_assoc_object_type_code IN VARCHAR2) IS
595:
596: CURSOR l_assoc_object_type_code_csr (p_assoc_object_type_code in varchar2) IS
597: SELECT 'Y'
598: From FND_LOOKUPS
599: Where lookup_type = 'OKL_VP_ASSOC_OBJECT_TYPES'
600: And nvl(enabled_flag,'N') = 'Y'
601: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
602: And lookup_code = p_assoc_object_type_code;