APPS.AST_UWQ_OPP_ENUMS_PVT SQL Statements

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

Line: 23

  l_src_code_select VARCHAR2(2);

Line: 26

    SELECT status_code, meaning
    FROM
      as_statuses_vl
    WHERE
      enabled_flag = 'Y' and OPP_FLAG = 'Y' and OPP_OPEN_STATUS_FLAG = 'Y';

Line: 47

  Select meaning into l_node_label
  from fnd_lookup_values_vl
  where lookup_type = 'IEU_NODE_LABELS'
  and view_application_id = 696
  and lookup_code = 'IEU_OPPORTUNITIES_LBL';

Line: 54

  Select meaning into l_node_label
  from ast_lookups
  where lookup_type = lkp_type
  and lookup_code = lkp_code;

Line: 60

  l_src_code_select := NVL(FND_PROFILE.VALUE('AST_SOURCE_UWQ_OPP'), 'N');

Line: 61

  IF (l_src_code_select = 'N') THEN
	l_view_name := 'AST_SALESOPP_UWQ_V';

Line: 64

  ELSIF (l_src_code_select = 'P') THEN
	l_view_name := 'AST_SALESOPP_CODE_UWQ_V';

Line: 67

  ELSIF (l_src_code_select = 'Y') THEN
	l_view_name := 'AST_SALESOPP_NAME_UWQ_V';

Line: 522

  l_src_code_select VARCHAR2(2);

Line: 525

    SELECT status_code, meaning
    FROM
      as_statuses_vl
    WHERE
      enabled_flag = 'Y' and OPP_FLAG = 'Y' and OPP_OPEN_STATUS_FLAG = 'Y';

Line: 545

  Select meaning into l_node_label
  from ast_lookups
  where lookup_type = lkp_type
  and lookup_code = lkp_code;

Line: 551

  l_src_code_select := NVL(FND_PROFILE.VALUE('AST_SOURCE_UWQ_OPP'), 'N');

Line: 552

  IF (l_src_code_select = 'N') THEN
	l_view_name := 'AST_MYTEAM_SALESOPP_UWQ_V';

Line: 555

  ELSIF (l_src_code_select = 'P') THEN
	l_view_name := 'AST_MYTEAM_SALESOPP_CODE_UWQ_V';

Line: 558

  ELSIF (l_src_code_select = 'Y') THEN
	l_view_name := 'AST_MYTEAM_SALESOPP_NAME_UWQ_V';