APPS.OKL_SO_CREDIT_APP_WF SQL Statements

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

Line: 18

   SELECT 'Y'
     FROM wf_event_subscriptions a,
          wf_events b
    WHERE a.event_filter_guid = b.guid
      AND a.status = 'ENABLED'
      AND b.name   = p_event_name
      AND rownum   = 1;

Line: 58

  select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;

Line: 74

   l_parameter_list.DELETE;

Line: 131

  select user_name name,user_name display_name
  from   fnd_user
  where  user_id=P_USER_ID
  and    employee_id is null
union all
  select
       USR.USER_NAME name, PER.FULL_NAME display_name
  from
       PER_PEOPLE_F PER,
       FND_USER USR
  where  trunc(SYSDATE)
      between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
    and    PER.PERSON_ID       = USR.EMPLOYEE_ID
    and USR.USER_ID = P_USER_ID;

Line: 148

select source_user_id
from   ar_cmgt_credit_requests
where  credit_request_id = b_credit_request_id;

Line: 234

select role, name
from
(select 1 num, FND_PROFILE.VALUE('OKL_CREDIT_ANALYST') role,
	   NVL(PER.FULL_NAME, USR.USER_NAME) name
   from FND_USER USR, PER_PEOPLE_F PER
  where USR.USER_NAME = FND_PROFILE.VALUE('OKL_CREDIT_ANALYST')
    and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
    and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
						 nvl(per.effective_end_date, trunc(sysdate))
);

Line: 324

    SELECT
        null  quote_number
        ,null credit_req_number
        ,to_number(null) credit_amount
        ,to_date(null) requested_date
        ,null account_number
        ,null party_name
        ,to_number(null) id                  -- okl credit request id
        ,to_number(null) quote_id
        ,null status              -- lookup code (not meaning)
        ,null currency_code
     from dual;

Line: 339

    SELECT
         credit_recommendation
        ,recommendation_value1
        ,recommendation_value2
   FROM  ar_cmgt_cf_recommends
   WHERE credit_request_id = b_credit_request_id;

Line: 602

  SELECT id
  FROM   OKC_LINE_STYLES_b
  WHERE  LTY_CODE = 'FREE_FORM';

Line: 608

  SELECT name
  FROM   okx_parties_v
  WHERE  id1 = b_party_id;

Line: 614

  SELECT
         limit_currency
        ,limit_amount
        ,trx_currency
        ,trx_amount
        ,party_id
        ,cust_account_id
        ,site_use_id
        ,application_date
  FROM   ar_cmgt_credit_requests
  WHERE  credit_request_id = b_credit_request_id;

Line: 628

  SELECT
     quote_id           -- this is actually the contract id.
    ,credit_req_number
    ,credit_req_id
    ,credit_amount
    ,approved_by
    ,approved_date
    ,status
    ,credit_khr_id
    ,currency_code
    ,org_id
    ,created_by
  FROM  okl_credit_requests
  WHERE credit_req_id = b_credit_request_id;

Line: 645

 SELECT INV_ORGANIZATION_ID FROM OKC_K_HEADERS_B
 WHERE ID = p_qte_id;

Line: 649

  SELECT credit_recommendation,
         recommendation_value1,
         recommendation_value2
  FROM   ar_cmgt_cf_recommends
  WHERE  credit_request_id = b_request_id ;

Line: 656

  SELECT resource_id
  FROM   jtf_rs_resource_extns
  WHERE  user_id = b_user_id;

Line: 661

  SELECT user_id
  FROM   fnd_user
  WHERE  user_name = b_user_name;

Line: 885

    SELECT OBJECT_VERSION_NUMBER
    INTO   l_crqv_rec_type.OBJECT_VERSION_NUMBER
    FROM   OKL_CREDIT_REQUESTS
    WHERE  ID = l_okl_credit_req ;

Line: 902

   okl_credit_request_pub.update_credit_request(
         p_api_version                  => l_api_version
        ,p_init_msg_list                => 'T'
        ,x_return_status                =>x_return_status
        ,x_msg_count                    => x_msg_count
        ,x_msg_data                     =>x_msg_data
        ,p_crqv_rec                     =>l_crqv_rec_type
        ,x_crqv_rec                     => x_crqv_rec_type);

Line: 1087

  PROCEDURE UPDATE_STATUS(
            itemtype    IN  VARCHAR2,
            itemkey     IN  VARCHAR2,
            actid       IN  NUMBER,
            funcmode    IN  VARCHAR2,
            resultout   OUT NOCOPY VARCHAR2)
  IS
    -- Variables Declarations
    l_api_version     CONSTANT NUMBER       DEFAULT G_INIT_VERSION;

Line: 1096

    l_api_name        CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_STATUS';

Line: 1109

      SELECT CCR.SOURCE_COLUMN1
           , LAB.CREATED_BY
           , LAB.PROSPECT_ID
           , LAB.CUST_ACCT_ID
           , LAB.ORG_ID
      FROM AR_CMGT_CREDIT_REQUESTS CCR
         , OKL_LEASE_APPS_ALL_B LAB
      WHERE CCR.SOURCE_COLUMN3 = 'LEASEAPP'
        AND CCR.SOURCE_COLUMN1 = LAB.ID
		AND CCR.CREDIT_REQUEST_ID = cp_credit_req_id;

Line: 1131

      SELECT credit_recommendation, status
      FROM ar_cmgt_cf_recommends
      WHERE credit_request_id = p_credit_request_id
        AND credit_recommendation IN ('REJECT','APPROVE');

Line: 1141

    L_MODULE := 'OKL.PLSQL.OKL_SO_CREDIT_APP_WF.UPDATE_STATUS';

Line: 1341

  END UPDATE_STATUS ;

Line: 1368

     SELECT SUM(KLE.CAPITAL_AMOUNT) ,chr.contract_number
      FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR
     WHERE chr.scs_code = 'QUOTE'
     AND chr.ID = l_quote_id
     AND  CLEB.ID = KLE.ID
     AND   CLEB.DNZ_CHR_ID = chr.ID
     AND CLEB.CLE_ID IS NULL
     GROUP  BY chr.ID , chr.contract_number;

Line: 1412

  select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;

Line: 1427

  okl_credit_request_pub.insert_credit_request(
     p_api_version                  => l_api_version
    ,p_init_msg_list                => 'T'
    ,x_return_status                =>x_return_status
    ,x_msg_count                    => x_msg_count
    ,x_msg_data                     =>x_msg_data
    ,p_crqv_rec                     =>l_crqv_rec_type
    ,x_crqv_rec                     => x_crqv_rec_type);