APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_CREDITCARD_ISSUERS_B

Line 4483: ci_issuer IBY_CREDITCARD_ISSUERS_B.CARD_ISSUER_CODE%TYPE

4479: AND TX.TRXNTYPEID=2
4480: AND TX.STATUS=0;
4481:
4482: CURSOR c_setup(ci_bepid iby_bepinfo.bepid%TYPE,
4483: ci_issuer IBY_CREDITCARD_ISSUERS_B.CARD_ISSUER_CODE%TYPE
4484: )
4485: IS
4486: SELECT NVL(B.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') BEP_FLAG,
4487: NVL(i.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') card_issuer_flag

Line 4488: FROM IBY_BEPINFO B, IBY_CREDITCARD_ISSUERS_B I

4484: )
4485: IS
4486: SELECT NVL(B.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') BEP_FLAG,
4487: NVL(i.ALLOW_CAPTURE_EX_AUTH_FLAG, 'Y') card_issuer_flag
4488: FROM IBY_BEPINFO B, IBY_CREDITCARD_ISSUERS_B I
4489: WHERE B.BEPID=ci_bepid
4490: AND I.CARD_ISSUER_CODE=ci_issuer;
4491:
4492: BEGIN

Line 5128: FROM iby_bepinfo b, iby_creditcard_issuers_b i

5124: G_LEVEL_STATEMENT,l_module_name);
5125:
5126: SELECT DECODE(b.auth_reversal_flag, 'M', DECODE(i.auth_reversal_flag,'M','Y','N'), 'N')
5127: INTO l_rev_allowed
5128: FROM iby_bepinfo b, iby_creditcard_issuers_b i
5129: WHERE b.bepid = l_settlement_trxn_rec.auth_bepid
5130: AND i.card_issuer_code = l_settlement_trxn_rec.auth_instrsubtype;
5131:
5132: iby_debug_pub.add('l_rev_allowed = '|| l_rev_allowed, G_LEVEL_STATEMENT,l_module_name);

Line 6151: iby_creditcard_issuers_b brand

6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,
6151: iby_creditcard_issuers_b brand
6152: WHERE (xt.trxn_extension_id = ci_extension_id)
6153: AND (xt.trxn_extension_id = op.trxn_extension_id)
6154: AND (op.transactionid = auth.transactionid)
6155: AND (auth.reqtype = 'ORAPMTREQ')