APPS.CN_WF_PMT_PKG SQL Statements

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

Line: 15

      G_last_updated_by       NUMBER  := fnd_global.user_id;

Line: 16

      G_last_update_login     NUMBER  := fnd_global.login_id;

Line: 32

     SELECT cnpt.commission_header_id commission_header_id, cnpt.quota_id  quota_id, pr.payrun_mode
     FROM   cn_payment_transactions_all cnpt, cn_payruns_all pr
     WHERE  cnpt.payment_transaction_id = p_posting_detail_id
     AND    cnpt.payrun_id = pr.payrun_id ;

Line: 39

        SELECT revenue_class_id revenue_class_id
    FROM  cn_commission_headers_all cnch
    WHERE cnch.commission_header_id = l_commission_header_id;

Line: 45

    SELECT nvl (payables_ccid_level, 'CUSTOM')
    FROM cn_repositories_all rp, cn_payment_transactions_all trxn
    WHERE  trxn.org_id = rp.org_id
    AND  trxn.payment_transaction_id = p_posting_detail_id ;

Line: 61

   SELECT p_posting_detail_id ||'--'|| to_char(sysdate, 'dd-mon-yyyy hh24:mi:sssss')
     INTO itemkey
     FROM dual;

Line: 161

procedure selector
  (   itemtype  in varchar2,
  itemkey   in varchar2,
  actid   in number,
  funcmode  in varchar2,
  resultout out nocopy varchar2 ) is
     --+
begin
   --+
   -- RUN mode - normal process execution
   --+
   if (funcmode = 'RUN') then
      --+
      -- Return process to run
      --+
      resultout := 'CNACCGEN';

Line: 183

      wf_core.context('CNACCGEN','Selector',itemtype,itemkey,actid,funcmode);

Line: 185

end selector;

Line: 199

procedure update_trx_ccid
  ( itemtype  in varchar2,
  itemkey   in varchar2,
  actid   in number,
  funcmode  in varchar2,
  resultout out nocopy varchar2 ) is

     l_return_status VARCHAR2(1);

Line: 229

      update cn_payment_transactions_all
  set expense_ccid = l_expense_ccid,
  liability_ccid = l_liability_ccid,
    --Update WHO columns for bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.
    LAST_UPDATE_DATE = SYSDATE,
  LAST_UPDATED_BY = G_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN
        where payment_transaction_id = l_posting_detail_id;

Line: 285

    select ruleset_id
    from cn_rulesets_all rs, cn_commission_headers_all ch
    where processed_date between start_date and end_date
    and commission_header_id = p_commission_header_id
    and  rs.org_id = ch.org_id
    and module_type = 'ACCGEN' ;

Line: 309

    SELECT pr.payrun_mode, pr.org_id , cnpt.incentive_type_code
    INTO   l_profile_value, l_cached_org_id, l_itc
    FROM   cn_payment_transactions_all cnpt, cn_payruns_all pr
    WHERE  cnpt.payment_transaction_id = l_payment_transaction_id
    AND    cnpt.payrun_id = pr.payrun_id ;

Line: 321

      SELECT expense_account_id, liability_account_id
      INTO   l_expense_ccid, l_liability_ccid
      FROM  cn_revenue_classes_all
      WHERE revenue_class_id = l_ccid_identifier;

Line: 330

      SELECT expense_account_id, liability_account_id
      INTO   l_expense_ccid, l_liability_ccid
      FROM   cn_quotas_all
      WHERE quota_id = l_ccid_identifier;

Line: 369

      SELECT expense_account_id, liability_account_id
      INTO   l_expense_ccid, l_liability_ccid
      FROM   cn_quotas_all
      WHERE  quota_id = l_ccid_identifier;