DBA Data[Home] [Help]

APPS.IBY_SCHED dependencies on IBY_TRANS_BANKACCT_V

Line 216: SELECT iby_trans_bankacct_v.TRANSACTIONID,

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,

Line 217: iby_trans_bankacct_v.STATUS,

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

Line 218: iby_trans_bankacct_v.UPDATEDATE,

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

Line 219: iby_trans_bankacct_v.REQTYPE,

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')

Line 220: iby_trans_bankacct_v.REFERENCECODE,

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;

Line 221: iby_trans_bankacct_v.TRXNMID

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:

Line 222: FROM iby_trans_bankacct_v

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;

Line 223: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')

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:

Line 224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;

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