APPS.OKC_TERMS_COPY_GRP SQL Statements

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

Line: 83

SELECT TARGET_RESPONSE_DOC_TYPE
FROM   okc_bus_doc_types_b
WHERE  document_type = p_target_doc_type
AND    document_type_class = 'SOURCING';

Line: 91

SELECT enable_deliverables_yn
FROM okc_bus_doc_types_b
where document_type = p_target_doc_type;

Line: 471

SELECT * FROM OKC_TERMS_TEMPLATES_ALL
WHERE template_id=p_template_id;

Line: 475

SELECT 'x' FROM OKC_TERMS_TEMPLATES_ALL
WHERE org_id=b_org_id
AND   template_name=p_tmpl_name;

Line: 524

    SELECT mo_global.get_current_org_id()
          INTO l_template_rec.org_id from dual;

Line: 812

SELECT TARGET_RESPONSE_DOC_TYPE
FROM   okc_bus_doc_types_b
WHERE  document_type = p_target_doc_type
AND    document_type_class = 'SOURCING';

Line: 820

SELECT doc_numbering_scheme
FROM okc_template_usages
WHERE document_type = p_doc_type
  AND document_id = p_doc_id;

Line: 828

SELECT enable_deliverables_yn
FROM   okc_bus_doc_types_b
WHERE  document_type = p_target_doc_type;

Line: 1097

SELECT * FROM OKC_TERMS_TEMPLATES_ALL
WHERE template_id=p_template_id;