eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_SCHED dependencies on IBY_TRANS_PCARD_V

Line 229: SELECT iby_trans_pcard_v.TRANSACTIONID,

225:
226: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
227:
228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
229: SELECT iby_trans_pcard_v.TRANSACTIONID,
230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,

Line 230: iby_trans_pcard_v.STATUS,

226: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
227:
228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
229: SELECT iby_trans_pcard_v.TRANSACTIONID,
230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID

Line 231: iby_trans_pcard_v.UPDATEDATE,

227:
228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
229: SELECT iby_trans_pcard_v.TRANSACTIONID,
230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v

Line 232: iby_trans_pcard_v.REQTYPE,

228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
229: SELECT iby_trans_pcard_v.TRANSACTIONID,
230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v
236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')

Line 233: iby_trans_pcard_v.REFERENCECODE,

229: SELECT iby_trans_pcard_v.TRANSACTIONID,
230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v
236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
237: AND iby_trans_pcard_v.ecappid = cin_ecappid;

Line 234: iby_trans_pcard_v.TRXNMID

230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v
236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
237: AND iby_trans_pcard_v.ecappid = cin_ecappid;
238:

Line 235: FROM iby_trans_pcard_v

231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v
236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
237: AND iby_trans_pcard_v.ecappid = cin_ecappid;
238:
239: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;

Line 236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')

232: iby_trans_pcard_v.REQTYPE,
233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v
236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
237: AND iby_trans_pcard_v.ecappid = cin_ecappid;
238:
239: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
240:

Line 237: AND iby_trans_pcard_v.ecappid = cin_ecappid;

233: iby_trans_pcard_v.REFERENCECODE,
234: iby_trans_pcard_v.TRXNMID
235: FROM iby_trans_pcard_v
236: WHERE iby_trans_pcard_v.needsupdt IN ('Y','F')
237: AND iby_trans_pcard_v.ecappid = cin_ecappid;
238:
239: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
240:
241: BEGIN