DBA Data[Home] [Help]

APPS.IBY_PAYMENT_ADAPTER_PUB dependencies on IBY_PAYMENTS_V

Line 1457: FROM IBY_PAYMENTS_V

1453: --NOTE* : **** IF INSTRTYPE IS NULL, this is assumed to be 'CREDITCARD' for release 11i ****.
1454:
1455: CURSOR pmtcanc_csr IS
1456: SELECT NVL(instrtype, 'CREDITCARD')
1457: FROM IBY_PAYMENTS_V
1458: WHERE transactionid = p_canctrxn_rec.Trxn_ID;
1459:
1460: BEGIN
1461: -- Standard Start of API savepoint

Line 1709: FROM IBY_PAYMENTS_V

1705:
1706: l_pmtinstr_type VARCHAR2(80); --for querying up instrument type from DB.
1707: CURSOR pmtqrytrxn_csr IS
1708: SELECT NVL(instrtype, 'CREDITCARD')
1709: FROM IBY_PAYMENTS_V
1710: WHERE transactionid = p_querytrxn_rec.Trxn_ID;
1711:
1712: BEGIN
1713: -- Standard Start of API savepoint

Line 3063: FROM IBY_PAYMENTS_V

3059: currencyNameCode,
3060: acctNo,
3061: refInfo,
3062: memo
3063: FROM IBY_PAYMENTS_V
3064: WHERE ecappid = p_ecapp_id
3065: AND transactionid = p_tid
3066: ORDER BY payeeid, payerid, tangibleid;
3067: