DBA Data[Home] [Help]

APPS.IBY_FIPAYMENTS_PKG dependencies on DUAL

Line 100: from dual;

96: l_cnt NUMBER := 0;
97:
98: cursor c_tmid is
99: select iby_trxnsumm_mid_s.nextval
100: from dual;
101:
102: cursor c_reference(ci_tangible_id iby_trxn_summaries_all.tangibleid%type) is
103: select proc_reference_code, amount
104: from iby_trxn_summaries_all

Line 550: from dual;

546: l_mpayeeid iby_payee.mpayeeid%type;
547:
548: cursor c_tmid is
549: select iby_trxnsumm_mid_s.nextval
550: from dual;
551:
552: cursor c_mtangibleid(ci_tid in iby_trxn_summaries_all.transactionid%type)
553: is
554: select mtangibleid , tangibleid

Line 701: from dual;

697: l_status iby_trxn_summaries_all.status%type;
698:
699: cursor c_tmid is
700: select iby_trxnsumm_mid_s.nextval
701: from dual;
702:
703: cursor getLatestTMID(ci_tid in iby_trxn_summaries_all.transactionId%type) is
704: select trxnmid , status
705: from iby_trxn_summaries_all s

Line 856: from dual;

852: l_reference_code iby_trxn_summaries_all.proc_reference_code%type;
853: l_trxn_exists VARCHAR2(1);
854: cursor c_tmid is
855: select iby_trxnsumm_mid_s.nextval
856: from dual;
857:
858: CURSOR trxn_exists IS
859: SELECT 'Y', trxnmid
860: FROM iby_trxn_summaries_all s