DBA Data[Home] [Help]

APPS.IEX_DUNNINGS_PKG dependencies on IEX_DUNNING_TRANSACTIONS

Line 414: FROM iex_dunning_transactions

410: , p_object_version_number NUMBER
411: ) IS
412: CURSOR l_insert IS
413: SELECT ROWID
414: FROM iex_dunning_transactions
415: WHERE dunning_trx_id = px_dunning_trx_id;
416: --
417: CURSOR get_seq_csr is
418: SELECT iex_dunning_transactions_s.nextval

Line 418: SELECT iex_dunning_transactions_s.nextval

414: FROM iex_dunning_transactions
415: WHERE dunning_trx_id = px_dunning_trx_id;
416: --
417: CURSOR get_seq_csr is
418: SELECT iex_dunning_transactions_s.nextval
419: FROM sys.dual;
420: BEGIN
421: --
422: If (px_dunning_trx_id IS NULL) OR (px_dunning_trx_id = FND_API.G_MISS_NUM) then

Line 429: INSERT INTO IEX_DUNNING_TRANSACTIONS (

425: CLOSE get_seq_csr;
426: End If;
427: --Start adding for bug 8489610 by gnramasa 14-May-09
428: --
429: INSERT INTO IEX_DUNNING_TRANSACTIONS (
430: DUNNING_TRX_ID
431: , DUNNING_ID
432: , CUST_TRX_ID
433: , PAYMENT_SCHEDULE_ID