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_OFFLINEDB_PKG dependencies on DUAL

Line 127: FROM dual;

123:
124: -- Get the master transaction id sequence for all requests
125: SELECT iby_trxnsumm_mid_s.NEXTVAL
126: INTO l_mid
127: FROM dual;
128:
129: -- insert the scheduled request in the summary and core tables
130: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
131: INSERT INTO iby_trxn_summaries_all

Line 239: FROM dual;

235: -- Get the master transaction id sequence for all requests
236:
237: SELECT iby_trxnsumm_mid_s.NEXTVAL
238: INTO l_mid
239: FROM dual;
240:
241: select mtangibleid, payerinstrid into l_tmid, l_instrid
242: from iby_trxn_summaries_all
243: where transactionid = i_transactionid

Line 314: FROM dual;

310: -- insert the request into the batch table
311:
312: SELECT iby_batches_s.NEXTVAL
313: INTO l_mbatchid
314: FROM dual;
315:
316: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
317: -- Bug:8363526. : Inserting value for new column iby_batches_all
318: -- Inserted column settledate value will be sysdate.

Line 424: --FROM dual;

420:
421: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
422: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
423: --INTO l_tid
424: --FROM dual;
425: io_transactionid := l_tid;
426: END IF;
427: -- Get the master transaction id sequence for all requests
428:

Line 431: FROM dual;

427: -- Get the master transaction id sequence for all requests
428:
429: SELECT iby_trxnsumm_mid_s.NEXTVAL
430: INTO l_mid
431: FROM dual;
432:
433: -- insert the scheduled request in the summary and core tables
434: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
435: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);

Line 508: FROM dual;

504: -- Get the master transaction id sequence for all requests
505:
506: SELECT iby_trxnsumm_mid_s.NEXTVAL
507: INTO l_mid
508: FROM dual;
509:
510: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
511: INSERT INTO iby_trxn_summaries_all
512: (TrxnMID, TransactionID, TangibleID,

Line 598: --FROM dual;

594:
595: l_tid := iby_transactioncc_pkg.getTID(i_payeeid, i_tangibleid);
596: --SELECT iby_trxnsumm_trxnid_s.NEXTVAL
597: --INTO l_tid
598: --FROM dual;
599: io_transactionid := l_tid;
600: END IF;
601: -- Get the master transaction id sequence for all requests
602:

Line 605: FROM dual;

601: -- Get the master transaction id sequence for all requests
602:
603: SELECT iby_trxnsumm_mid_s.NEXTVAL
604: INTO l_mid
605: FROM dual;
606: -- insert the scheduled request in the summary and core tables
607: iby_transactioncc_pkg.getMBatchId(batchid, i_payeeid, l_mbatchid);
608: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
609: INSERT INTO iby_trxn_summaries_all

Line 686: FROM dual;

682:
683: -- insert the request into the batch table
684: SELECT iby_batches_s.NEXTVAL
685: INTO l_mbatchid
686: FROM dual;
687: iby_accppmtmthd_pkg.getMPayeeId(i_payeeid, l_mpayeeid);
688: -- Bug: 8363526: Inserted new column settledate for tableiby_batches_all
689: INSERT INTO iby_batches_all
690: (MBatchID, BatchID, MPayeeID, PayeeID, BEPID, ECAppID,