DBA Data[Home] [Help]

APPS.IBY_PAYMENT_ADAPTER_PUB dependencies on IBY_PAYMENTS_V

Line 1776: FROM IBY_PAYMENTS_V

1772: --NOTE* : **** IF INSTRTYPE IS NULL, this is assumed to be 'CREDITCARD' for release 11i ****.
1773:
1774: CURSOR pmtcanc_csr IS
1775: SELECT NVL(instrtype, 'CREDITCARD')
1776: FROM IBY_PAYMENTS_V
1777: WHERE transactionid = p_canctrxn_rec.Trxn_ID;
1778:
1779: BEGIN
1780: -- Standard Start of API savepoint

Line 2028: FROM IBY_PAYMENTS_V

2024:
2025: l_pmtinstr_type VARCHAR2(80); --for querying up instrument type from DB.
2026: CURSOR pmtqrytrxn_csr IS
2027: SELECT NVL(instrtype, 'CREDITCARD')
2028: FROM IBY_PAYMENTS_V
2029: WHERE transactionid = p_querytrxn_rec.Trxn_ID;
2030:
2031: BEGIN
2032: -- Standard Start of API savepoint

Line 3384: FROM IBY_PAYMENTS_V

3380: currencyNameCode,
3381: acctNo,
3382: refInfo,
3383: memo
3384: FROM IBY_PAYMENTS_V
3385: WHERE ecappid = p_ecapp_id
3386: AND transactionid = p_tid
3387: ORDER BY payeeid, payerid, tangibleid;
3388: