DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on GME_TRANSACTION_PAIRS

Line 534: FROM gme_transaction_pairs

530: AND transaction_source_id = v_batch_id
531: AND transaction_source_type_id = v_txn_source_type
532: AND NOT EXISTS ( SELECT /*+ no_unnest */
533: transaction_id1
534: FROM gme_transaction_pairs
535: WHERE transaction_id1 = mmt.transaction_id
536: AND pair_type = v_pairs_reversal_type)
537: AND NVL (transaction_date, p_batch_header_rec.batch_close_date) >
538: p_batch_header_rec.batch_close_date