APPS.IBY_PAYMENT_ADAPTER_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 1218: CURSOR c_auth (ci_transactionid iby_trxn_summaries_all.transactionid%TYPE)

1214:
1215: l_module CONSTANT VARCHAR2(30) := 'OraPmtReverse';
1216: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
1217:
1218: CURSOR c_auth (ci_transactionid iby_trxn_summaries_all.transactionid%TYPE)
1219: IS
1220: SELECT payerinstrid, instrtype
1221: FROM iby_trxn_summaries_all
1222: WHERE transactionid = ci_transactionid

Line 1221: FROM iby_trxn_summaries_all

1217:
1218: CURSOR c_auth (ci_transactionid iby_trxn_summaries_all.transactionid%TYPE)
1219: IS
1220: SELECT payerinstrid, instrtype
1221: FROM iby_trxn_summaries_all
1222: WHERE transactionid = ci_transactionid
1223: AND trxntypeid = 2
1224: AND status = 0;
1225:

Line 1227: l_pmtinstr_type iby_trxn_summaries_all.instrtype%TYPE;

1223: AND trxntypeid = 2
1224: AND status = 0;
1225:
1226: l_instrid VARCHAR2(30);
1227: l_pmtinstr_type iby_trxn_summaries_all.instrtype%TYPE;
1228:
1229: BEGIN
1230: --dbms_output.put_line(l_dbg_mod||': Enter');
1231: iby_debug_pub.add('Enter', FND_LOG.LEVEL_PROCEDURE,l_dbg_mod);