APPS.AMS_UTILITY_PVT dependencies on FND_LOOKUP_VALUES

Line 302: SELECT 1 FROM fnd_lookup_values lkup

298: IS
299: CURSOR cur_check_lookup_exists( p_lookup_type VARCHAR2
300: , p_lookup_code VARCHAR2
301: , p_view_app_id NUMBER) IS
302: SELECT 1 FROM fnd_lookup_values lkup
303: WHERE lkup.LOOKUP_TYPE = p_lookup_type
304: AND lkup.LOOKUP_CODE = p_lookup_code
305: AND lkup.view_application_id = p_view_app_id
306: AND lkup.ENABLED_FLAG = 'Y'