APPS.GME_CLOSE_BATCH_PVT dependencies on GME_TRANSACTION_PAIRS

Line 638: FROM gme_transaction_pairs

634: AND transaction_source_id = v_batch_id
635: AND transaction_source_type_id = v_txn_source_type
636: AND NOT EXISTS ( SELECT /*+ no_unnest */
637: transaction_id1
638: FROM gme_transaction_pairs
639: WHERE transaction_id1 = mmt.transaction_id
640: AND pair_type = v_pairs_reversal_type)
641: AND NVL (transaction_date, p_batch_header_rec.batch_close_date) >
642: p_batch_header_rec.batch_close_date