APPS.OKL_KBK_APPROVALS_WF SQL Statements

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

Line: 88

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

Line: 95

    SELECT USER_NAME, DESCRIPTION
    FROM   FND_USER
    WHERE  user_id = c_user_id;

Line: 142

    Okl_Contract_Status_Pub.update_contract_status(
                            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_khr_status    => p_khr_status,
                            p_chr_id        => p_chr_id);

Line: 233

    SELECT chrv.contract_number,
           chrv.sts_code
    FROM okc_k_headers_v chrv
    WHERE chrv.id = p_contract_id;

Line: 241

    SELECT APPLICATION_ID
    FROM   FND_APPLICATION
    WHERE  APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 250

    SELECT B.TRANSACTION_TYPE_ID,
           B.FND_APPLICATION_ID
      FROM AME_CALLING_APPS B,
           AME_CALLING_APPS_TL T
     WHERE B.APPLICATION_ID = T.APPLICATION_ID
       AND T.LANGUAGE = 'US'
       AND T.APPLICATION_NAME = c_trx_type;

Line: 259

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;

Line: 263

    SELECT id
    FROM   okl_trx_types_b
    WHERE  trx_type_class = G_TRX_TYPE_CONTRACT_APPROVAL;

Line: 270

      SELECT created_by
        FROM okc_k_headers_all_b
       WHERE id = p_khr_id;

Line: 501

     l_parameter_list.DELETE;

Line: 596

      SELECT chrv.contract_number,
             chrv.sts_code,
             stsv.meaning,
             chrv.description,
             chrv.currency_code,
             pdtv.name product,
             chrv.deal_type,
             chrv.start_date,
             chrv.end_date,
             lgle.name legal_name,
             INITCAP(REPLACE(ru.rule_information1,'_',' ')) eto,
             ru.rule_information2 etm,
             Okl_Am_Util_Pvt.get_party_name(chrv.id,'PRIVATE_LABEL') Pvt_Label,
             chrv.pre_tax_irr,
             chrv.after_tax_irr,
             chrv.implicit_interest_rate,
             chrv.after_tax_yield
      FROM okc_rules_b ru,
           okc_rule_groups_b rg,
           xle_entity_profiles lgle,
           okl_k_headers_full_v chrv,
           okl_products_v pdtv,
           okc_statuses_v stsv
      WHERE chrv.id = p_contract_id
      AND lgle.legal_entity_id = chrv.legal_entity_id
      AND rg.dnz_chr_id = chrv.id
      AND rg.rgd_code = 'AMTFOC'
      AND ru.rgp_id = rg.id
      AND ru.rule_information_category = 'AMBPOC'
      AND pdtv.id = chrv.pdt_id
      AND chrv.sts_code = stsv.code;

Line: 632

      SELECT DNZ_CHECKLIST_OBJ_ID,
             TODO_ITEM_CODE,
             TODO_ITEM_MEANING,
             MANDATORY_FLAG_MEANING,
             MANDATORY_FLAG,
             USER_COMPLETE_FLAG_RESULTS,
             FUNCTION_VALIDATE_RSTS_MEANING,
             FUNCTION_ID,
             FUNCTION_NAME,
             CHECKIST_RESULTS
      FROM okl_instance_checklist_dtl_uv
      WHERE DNZ_CHECKLIST_OBJ_ID =  p_chr_id;

Line: 647

select 1
 from okc_k_headers_b
 where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
 and id = p_contract_id;

Line: 1137

    SELECT USER_NAME
    FROM   FND_USER
    WHERE  user_id = p_user_id;

Line: 1301

  PROCEDURE update_approval_status(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 Project
        AND    representation_type = 'PRIMARY';

Line: 1323

	l_api_name VARCHAR2(30) := 'update_approval_status';

Line: 1402

        Okl_Trx_Contracts_Pub.update_trx_contracts(
             p_api_version      => l_api_version
            ,p_init_msg_list    => l_init_msg_list
            ,x_return_status    => l_return_status
            ,x_msg_count        => l_msg_count
            ,x_msg_data         => l_msg_data
            ,p_tcnv_rec         => l_trxH_in_rec
            ,x_tcnv_rec         => l_trxH_out_rec);

Line: 1501

  END update_approval_status;

Line: 1710

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;