APPS.CN_SCA_UTL_PVT SQL Statements

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

Line: 38

    l_select_stmt  VARCHAR2(4000);

Line: 39

    l_select       VARCHAR2(4000);

Line: 45

    l_select  := l_valueset_r.table_info.value_column_name ||' column_name, ' ||
     		      NVL(l_valueset_r.table_info.id_column_name, 'null') || ' column_id, ' ||
                  NVL(l_valueset_r.table_info.meaning_column_name, 'null') || ' column_meaning';

Line: 57

   l_select_stmt := 'Select ' || l_select || ' from ' || l_from || ' ' || l_where ;

Line: 59

   return l_select_stmt;

Line: 90

   SELECT /*+ ORDERED INDEX(b) */ a.src_column_name
     FROM cn_sca_rule_attributes_all_b a,
          cn_sca_conditions b
    WHERE a.sca_rule_attribute_id = b.sca_rule_attribute_id
      AND a.transaction_source = p_transaction_source
      AND a.enabled_flag = 'Y'
      AND a.org_id = p_org_id
    GROUP BY a.src_column_name;

Line: 100

   SELECT aidx.owner, aidx.index_name
     FROM all_indexes aidx
    WHERE aidx.table_name = 'CN_SCA_HEADERS_INTERFACE_ALL'
      AND aidx.table_owner = l_table_owner
      AND aidx.index_name LIKE 'CN_SCA_HEADERS_INTERFACE_A%';

Line: 110

   SELECT application_short_name
     INTO l_cn_schema
     FROM fnd_application
    WHERE application_id = 283;

Line: 155

   SELECT i.tablespace, i.index_tablespace, u.oracle_username
     INTO l_table_tablespace, l_idx_tablespace, l_ora_username
     FROM fnd_product_installations i, fnd_application a, fnd_oracle_userid u
    WHERE a.application_short_name = l_cn_schema
      AND a.application_id = i.application_id
      AND u.oracle_id = i.oracle_id;