APPS.OKC_TERMS_QA_GRP SQL Statements

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

Line: 10

    G_RECORD_DELETED             CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

Line: 12

    G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line: 85

       SELECT fnd.lookup_code qa_code,
             fnd.meaning qa_name,
             nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
             decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
        FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA
        WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
        AND   QA.QA_CODE(+) = FND.LOOKUP_CODE
        AND   FND.LOOKUP_CODE = 'CHECK_TERMS_EXIST'
        AND   Fnd.LOOKUP_TYPE=G_QA_LOOKUP;

Line: 96

       SELECT template_id
        FROM  OKC_TEMPLATE_USAGES
        WHERE document_type = p_doc_type
        AND   document_id = p_doc_id;

Line: 434

       SELECT template_id
        FROM  OKC_TEMPLATE_USAGES
        WHERE document_type = p_doc_type
        AND   document_id = p_doc_id;