APPS.CCT_LKUP_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

  SELECT lv.MEANING, lv.lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV
  WHERE LV.VIEW_APPLICATION_ID = 0
  AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
  AND LV.ENABLED_FLAG='Y'
  AND LV.LANGUAGE = p_env_lang
  AND LV.LOOKUP_TYPE = 'CCT_BOOLEAN';

Line: 189

  SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV
  WHERE LV.VIEW_APPLICATION_ID = 0
  AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
  AND LV.ENABLED_FLAG='Y'
  AND LV.LANGUAGE = p_env_lang
  AND LV.LOOKUP_TYPE = 'CCT_TRACE_LEVELS';

Line: 268

  SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV
  WHERE LV.VIEW_APPLICATION_ID = 0
  AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
  AND LV.ENABLED_FLAG='Y'
  AND LV.LANGUAGE = p_env_lang
  AND LV.LOOKUP_TYPE = 'CCT_TEST_TYPES';

Line: 338

  select config_name bulk collect into x_lov_data
    from CCT_MIDDLEWARES mw
    where mw.server_group_id = p_server_group_id
	  AND mw.f_deletedflag is NULL;

Line: 395

  select config_name || ': ' || route_point_number bulk collect into x_lov_data
    from CCT_MIDDLEWARES mw, CCT_MW_ROUTE_POINTS rp
    where mw.middleware_id = rp.middleware_id
	  AND mw.server_group_id = p_server_group_id
	  AND rp.f_deletedflag is NULL;