APPS.OKL_QA_CHECK_PUB SQL Statements

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

Line: 27

    SELECT STS_CODE,
           SCS_CODE,
           CONTRACT_NUMBER
    FROM   OKC_K_HEADERS_B
    WHERE  ID = p_chr_id;

Line: 37

    SELECT count(1)
    FROM   okl_rbk_selected_contract
    WHERE  khr_id = p_chr_id
    AND    NVL(status,'NEW') = 'UNDER REVISION';

Line: 44

    SELECT 'Y'
    FROM   OKC_K_HEADERS_B
    WHERE  ID = p_chr_id
    AND QCL_ID IS NOT NULL;