APPS.OKC_SBCR_DT_PKG SQL Statements

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

Line: 63

  SELECT ag.descriptive_flex_context_code attr_group,
         ag.attr_group_id attr_group_id,
         ag.descriptive_flexfield_name desc_flexfld_name
  FROM ego_fnd_dsc_flx_ctx_ext ag
  WHERE ag.attr_group_id IN (SELECT DISTINCT ext.attr_group_id FROM okc_rep_contracts_all_ext_b ext WHERE ext.contract_id = p_contract_id)
        AND ag.multi_row = 'N';

Line: 71

  SELECT efdfce.attr_id,
         efdfce.application_column_name,
         fcu.end_user_column_name,
         fcu.flex_value_set_id,
         efdfce.data_type
  FROM ego_fnd_df_col_usgs_ext efdfce ,
       fnd_descr_flex_column_usages fcu
  WHERE efdfce.descriptive_flexfield_name = p_desc_flexfld_name
        AND efdfce.descriptive_flex_context_code  = p_attr_group
        AND fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
        AND fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
        AND fcu.application_column_name = efdfce.application_column_name
        AND fcu.display_flag <> 'H';

Line: 94

      l_sql := l_sql || ',' || '(SELECT XMLELEMENT("' || rec.attr_group || '", XMLFOREST(' ;

Line: 96

      l_sql := '(SELECT XMLELEMENT("' || rec.attr_group || '", XMLFOREST(';

Line: 122

  l_op := 'SELECT XMLCONCAT(' || l_sql || ') FROM dual';

Line: 145

  SELECT fcu.application_column_name INTO l_rec_type_col_name
  FROM fnd_descr_flex_column_usages fcu
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
        AND fcu.end_user_column_name = 'RECOMMENDATION_TYPE';

Line: 151

  SELECT fcu.application_column_name INTO l_rec_percent_col_name
  FROM fnd_descr_flex_column_usages fcu
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
        AND fcu.end_user_column_name = 'RECOMMEND_PERCENT';

Line: 157

  SELECT attr_group_id INTO l_attr_group_id
  FROM ego_fnd_dsc_flx_ctx_ext
  WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND descriptive_flex_context_code = 'SBCR_REC_AG';

Line: 162

  l_sql := 'SELECT lkup.lookup_code, nvl2(ext.' || l_rec_type_col_name || ', ''Y'', ''N''), ext.' || l_rec_percent_col_name || ' FROM okc_rep_contracts_all_ext_b ext, fnd_lookups lkup' ||
           ' WHERE ext.contract_id(+) = ' || p_contract_id || ' AND ext.attr_group_id (+) = ' || l_attr_group_id ||
           ' AND lkup.lookup_type = ''OKC_REP_SBCR_REC_SET_ASIDE'' AND lkup.enabled_flag = ''Y''' ||
           ' AND TRUNC(SYSDATE) BETWEEN lkup.start_date_active AND nvl(lkup.end_date_active, SYSDATE)' ||
           ' AND lkup.lookup_code = ext.' || l_rec_type_col_name || '(+)';

Line: 179

  l_final_sql := ' SELECT XMLConcat(' || l_xml_sql || ') FROM dual';

Line: 205

  SELECT fcu.application_column_name INTO l_prev_acq_type_col_name
  FROM fnd_descr_flex_column_usages fcu
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_PRE_ACQ'
        AND fcu.end_user_column_name = 'ACQ_PREV';

Line: 211

  SELECT fcu.application_column_name INTO l_prev_acq_cmt_col_name
  FROM fnd_descr_flex_column_usages fcu
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_PRE_ACQ'
        AND fcu.end_user_column_name = 'ACQ_COMMENTS';

Line: 217

  SELECT attr_group_id INTO l_attr_group_id
  FROM ego_fnd_dsc_flx_ctx_ext
  WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND descriptive_flex_context_code = 'SBCR_PRE_ACQ';

Line: 222

  l_sql := 'SELECT ' || l_prev_acq_type_col_name || ', ' || l_prev_acq_cmt_col_name ||
           ' FROM okc_rep_contracts_all_ext_b' ||
           ' WHERE contract_id = ' || p_contract_id ||
           ' AND attr_group_id = ' || l_attr_group_id ||
           ' AND ' || l_prev_acq_type_col_name || ' IS NOT NULL';

Line: 239

  l_final_sql := ' SELECT XMLConcat(' || l_xml_sql || ') FROM dual';

Line: 262

  SELECT fcu.application_column_name, efdfce.attr_id, efdfce.data_type
  INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type
  FROM fnd_descr_flex_column_usages fcu,
       ego_fnd_df_col_usgs_ext efdfce
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'
        AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'
        AND efdfce.descriptive_flexfield_name = fcu.descriptive_flexfield_name
        AND efdfce.descriptive_flex_context_code = fcu.descriptive_flex_context_code
        AND efdfce.application_column_name = fcu.application_column_name;

Line: 273

  SELECT attr_group_id INTO l_attr_group_id
  FROM ego_fnd_dsc_flx_ctx_ext
  WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND descriptive_flex_context_code = 'SBCR_PROC_INFO_AG';

Line: 278

  l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||
           ' FROM okc_rep_contracts_all_ext_b' ||
           ' WHERE contract_id = ' || p_contract_id ||
           ' AND attr_group_id = ' || l_attr_group_id ||
           ' AND ' || l_sbcr_size_standard_col_name || ' like ''%EMP%''';

Line: 293

  l_sql_desc := 'SELECT ' || l_sql_desc ||
                ' FROM okc_rep_contracts_all_ext_b' ||
	           ' WHERE contract_id = ' || p_contract_id ||
	           ' AND attr_group_id = ' || l_attr_group_id;

Line: 321

  SELECT fcu.application_column_name, efdfce.attr_id, efdfce.data_type
  INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type
  FROM fnd_descr_flex_column_usages fcu,
       ego_fnd_df_col_usgs_ext efdfce
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'
        AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'
        AND efdfce.descriptive_flexfield_name = fcu.descriptive_flexfield_name
        AND efdfce.descriptive_flex_context_code = fcu.descriptive_flex_context_code
        AND efdfce.application_column_name = fcu.application_column_name;

Line: 332

  SELECT attr_group_id INTO l_attr_group_id
  FROM ego_fnd_dsc_flx_ctx_ext
  WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND descriptive_flex_context_code = 'SBCR_PROC_INFO_AG';

Line: 337

  l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||
           ' FROM okc_rep_contracts_all_ext_b' ||
           ' WHERE contract_id = ' || p_contract_id ||
           ' AND attr_group_id = ' || l_attr_group_id ||
           ' AND ' || l_sbcr_size_standard_col_name || ' like ''%$%''';

Line: 352

  l_sql_desc := 'SELECT ' || l_sql_desc ||
                ' FROM okc_rep_contracts_all_ext_b' ||
	           ' WHERE contract_id = ' || p_contract_id ||
	           ' AND attr_group_id = ' || l_attr_group_id;

Line: 376

  SELECT fcu.application_column_name INTO l_rec_type_col_name
  FROM fnd_descr_flex_column_usages fcu
  WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
        AND fcu.end_user_column_name = 'RECOMMENDATION_TYPE';

Line: 382

  SELECT attr_group_id INTO l_attr_group_id
  FROM ego_fnd_dsc_flx_ctx_ext
  WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
        AND descriptive_flex_context_code = 'SBCR_REC_AG';

Line: 387

  l_sql := 'SELECT ''Y''' ||
           ' FROM okc_rep_contracts_all_ext_b' ||
           ' WHERE contract_id = ' || p_contract_id ||
           ' AND attr_group_id = ' || l_attr_group_id ||
           ' AND ' || l_rec_type_col_name || ' like ''SEC8A%''';