212:
213: -- r_trans_fi c_trans_fi%ROWTYPE;
214:
215: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
216: SELECT iby_trans_bankacct_v.TRANSACTIONID,
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
213: -- r_trans_fi c_trans_fi%ROWTYPE;
214:
215: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
216: SELECT iby_trans_bankacct_v.TRANSACTIONID,
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
214:
215: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
216: SELECT iby_trans_bankacct_v.TRANSACTIONID,
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
215: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
216: SELECT iby_trans_bankacct_v.TRANSACTIONID,
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
216: SELECT iby_trans_bankacct_v.TRANSACTIONID,
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
225:
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
225:
226: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
219: iby_trans_bankacct_v.REQTYPE,
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
225:
226: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
227:
220: iby_trans_bankacct_v.REFERENCECODE,
221: iby_trans_bankacct_v.TRXNMID
222: FROM iby_trans_bankacct_v
223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
225:
226: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
227:
228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS