APPS.IBY_PAYMENTMANAGERDB_PKG SQL Statements

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

Line: 197

    SELECT a.INSTRUMENT_TYPE INTO l_instr_type
      FROM IBY_FNDCPT_ALL_PMT_CHANNELS_V a
      WHERE a.PAYMENT_CHANNEL_CODE = p_payment_channel_code;

Line: 206

    SELECT a.mpayeeid INTO l_mpayeeid
      FROM IBY_PAYEE a
      WHERE a.payeeid = p_payee_id;

Line: 211

      SELECT bank_id INTO l_bank_id
      FROM ce_bank_accounts_v
      WHERE (bank_account_id = p_int_bank_acct_id);

Line: 282

                    SELECT p.name INTO l_payeename FROM iby_payee p
                    WHERE px_payee_id_in_out = p.payeeid;

Line: 284

                    SELECT b.name INTO l_bepname FROM iby_bepinfo b
                    WHERE x_bepid_out = b.bepid;

Line: 330

      SELECT distinct BEPID,a.TangibleID, PayeeID, b.currencynamecode,
	     instrtype, bepkey, PROCESS_PROFILE_CODE
        INTO x_bepid_out,px_order_id_in_out, px_payee_id_in_out, l_currency,
	   --
	   -- unfortunately pmt instr type is not passed for
	   -- follow-on trxns so it must also be fetched from the DB
	   --   [bug # 1925098]
	   --
	     l_routing_fields.instr_type, x_bep_key_out,
	     x_fndcpt_user_profile_code_out
        FROM iby_trxn_summaries_all a, iby_tangible b
       WHERE TransactionID = p_transaction_id_in
		AND a.mtangibleid = b.mtangibleid
        -- previously must have succeeded ones
        -- 100 is for processors, indicating it is in an open batch
        -- Added the conditions for Bankaccount
        AND ( ((NOT instrtype IS NULL) AND status in (0, 11, 100, 9)) OR ((instrtype = 'BANKACCOUNT') AND status <> -99) );

Line: 405

      SELECT Username, Password, '2147483647'
        INTO x_payee_username_out, x_payee_passwd_out,
		x_payee_operation_out
        FROM iby_payee
        WHERE PayeeID = px_payee_id_in_out
          AND upper(Activestatus) = 'Y';

Line: 488

	SELECT count(Key)
	INTO l_key_count
	FROM iby_bepkeys
	WHERE (OwnerId = p_payee_id) AND (BEPId = x_bepid_out) AND (Key = p_bepkey);

Line: 531

  SELECT a.paymentmethodname, a.paymentmethodid FROM  iby_routinginfo a
    WHERE  a.configured = 1
      -- Once financing supports multiple payees, the payee condition should
      -- be changed from 'like' back to '='
      -- AND  a.payeeid = p_payeeid
      AND  a.payeeid like p_payeeid
      AND  a.instr_type = p_instrtype
      AND NVL(a.instr_sub_type, ' ') = NVL(p_instr_subtype, ' ')
    ORDER BY a.priority;

Line: 542

  SELECT * FROM iby_pmtmthd_conditions x
    WHERE x.paymentmethodid = p_key order by x.entry_sequence ;

Line: 837

  SELECT hitcounter
    INTO l_hitcounter
    FROM iby_routinginfo
   WHERE paymentmethodname = px_pmt_name_in_out;

Line: 844

  UPDATE iby_routinginfo
     SET hitcounter = l_hitcounter
   WHERE paymentmethodname = px_pmt_name_in_out;

Line: 890

    SELECT bepid , baseurl
      INTO o_bepid, o_bep_base_url
      FROM iby_bepinfo
     WHERE suffix = i_suffix;

Line: 956

		SELECT instrtype FROM iby_accttype a, iby_accppmtmthd b
		WHERE a.accttypeid = b.accttypeid
		AND b.payeeid = ci_payeeid
		AND b.status = 1
		AND a.instrtype = ci_instr_type;

Line: 964

		SELECT FINANCING_PAYEE_FLAG FROM iby_payee
		WHERE payeeid = ci_payeeid;

Line: 1007

      SELECT beplang
        FROM iby_BEPlangs
       WHERE BEPID = ci_bepid
	AND Preferred = 0
	AND BEPLang <> '' AND BEPLang IS NOT NULL; -- reject anything trivial

Line: 1027

    SELECT count(*)
      INTO l_bep_lang_count
      FROM iby_BEPlangs
      WHERE BEPID = i_bepid
        AND UPPER(BEPlang) = UPPER(io_beplang);

Line: 1083

      SELECT p.PmtSchemename
        FROM iby_pmtschemes p, iby_bepinfo b
       WHERE p.bepid = b.bepid
         AND b.bepid = ci_bepid
	AND p.PMTSCHEMENAME IN (ci_name1, ci_name2, ci_name3);

Line: 1182

    	SELECT b.bepid, r.bepkey, r.fndcpt_user_profile_code
        FROM iby_routinginfo r, iby_bepinfo b
     	WHERE r.paymentmethodname = ci_paymentmethodname
	AND r.configured = 1
	AND r.bepid = b.bepid;

Line: 1219

	SELECT a.bepid,
	       c.key,
           a.fndcpt_user_profile_code
	FROM iby_default_bep a, iby_bepinfo b, iby_bepkeys c
	WHERE a.payment_channel_code = ci_payment_channel_code
	AND a.mpayeeid = ci_mpayeeid
	AND a.bepid = b.bepid
	AND UPPER(b.activeStatus) = 'Y'
    AND c.bep_account_id = a.bep_account_id;

Line: 1254

    SELECT suffix, baseurl, securityscheme, BEPUsername, BEPPassword, bep_type, leadtime
    FROM iby_bepinfo
    WHERE bepid = ci_bepid;