APPS.OKL_SEC_AGREEMENT_WF SQL Statements

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

Line: 101

    SELECT NAME, DISPLAY_NAME
    FROM   WF_USERS
    WHERE  orig_system_id = c_user_id
   	AND    ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;

Line: 108

    SELECT USER_NAME, DESCRIPTION
    FROM   FND_USER
    WHERE  user_id = c_user_id;

Line: 185

       fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before  Pool Transaction update call ');

Line: 191

    OKL_POOL_PVT.update_pool_transaction(p_api_version    => p_api_version,
                                         p_init_msg_list  => p_init_msg_list,
                                         x_return_status  => x_return_status,
                                         x_msg_count      => x_msg_count,
                                         x_msg_data       => x_msg_data,
                                         p_poxv_rec      => lp_poxv_rec,
                                         x_poxv_rec      => lx_poxv_rec);

Line: 200

       fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'After  Pool Transaction update call x_return_status ' || x_return_status);

Line: 300

    SELECT chrv.contract_number
    FROM okc_k_headers_v chrv
    WHERE chrv.id = p_agreement_id;

Line: 307

    SELECT pol.pool_number
    FROM okl_pools_all pol
    WHERE pol.id = p_pool_id ;

Line: 314

    SELECT APPLICATION_ID
    FROM   FND_APPLICATION
    WHERE  APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 321

    SELECT DESCRIPTION transaction_type_id,
           FND_APPLICATION_ID fnd_application_id
    FROM AME_TRANSACTION_TYPES_V
    WHERE TRANSACTION_TYPE_ID=c_trx_type;

Line: 327

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;

Line: 512

     l_parameter_list.DELETE;

Line: 612

     SELECT  OPA.POOL_NUMBER
      , OKC.CONTRACT_NUMBER  AGREEMENT_NUMBER
      , FND_REASON.MEANING TRANSACTION_REASON
     , FND.MEANING TRANSACTION_STATUS
      , SUM(STRM.AMOUNT) STREAM_VALUE
     , OPT.TRANSACTION_NUMBER
      , OPT.TRANSACTION_DATE
    FROM OKL_POOL_CONTENTS OPC
      ,OKL_POOL_TRANSACTIONS OPT
      ,OKL_STRM_ELEMENTS STRM
      ,FND_LOOKUPS FND
      ,FND_LOOKUPS FND_REASON
      ,OKL_POOLS_ALL OPA
      ,OKC_K_HEADERS_ALL_B OKC
      WHERE OPT.POL_ID = p_pool_id
      AND OPT.TRANSACTION_REASON = 'ADJUSTMENTS'
      AND OPT.TRANSACTION_TYPE = 'ADD'
      AND OPT.POL_ID = OPA.ID
      AND OPT.TRANSACTION_STATUS = FND.LOOKUP_CODE
      AND FND.LOOKUP_TYPE = 'OKL_POOL_TRANSACTION_STATUS'
      AND OPC.POX_ID = OPT.ID
      AND OPT.ID = p_pool_trans_id
      AND OPC.POL_ID = OPT.POL_ID
      AND OPC.STM_ID = STRM.STM_ID
      AND STRM.STREAM_ELEMENT_DATE BETWEEN OPC.STREAMS_FROM_DATE AND NVL(OPC.STREAMS_TO_DATE,OPC.STREAMS_FROM_DATE)
      AND OKC.ID = p_inv_agrmnt_id
      AND OPT.TRANSACTION_REASON = FND_REASON.LOOKUP_CODE
      AND FND_REASON.LOOKUP_TYPE = 'OKL_POOL_TRANSACTION_REASON'
    GROUP BY
      OPT.TRANSACTION_REASON,
      OPT.ID,
      POX_ID,
      FND.MEANING,
      FND_REASON.MEANING,
      OPT.TRANSACTION_NUMBER,
      OPT.TRANSACTION_DATE,
      OPA.POOL_NUMBER,
      OKC.CONTRACT_NUMBER;

Line: 813

    SELECT USER_NAME
    FROM   FND_USER
    WHERE  user_id = p_user_id;

Line: 986

  PROCEDURE update_add_khr_apprv_sts(itemtype  IN  VARCHAR2,
                                   itemkey   IN  VARCHAR2,
                                   actid     IN  NUMBER,
                                   funcmode  IN  VARCHAR2,
                                   resultout OUT NOCOPY VARCHAR2)
  IS
    CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
    IS
   	SELECT id
    FROM   okl_trx_contracts
   	WHERE  trx_number = p_trx_number
        --rkuttiya added for 12.1.1 Multi GAAP
        AND    representation_type = 'PRIMARY';

Line: 1006

    l_api_name             CONSTANT VARCHAR2(30) := 'update_add_khr_apprv_sts';

Line: 1113

  END update_add_khr_apprv_sts;

Line: 1304

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;