DBA Data[Home] [Help]

APPS.GHG_TRANSACTION_BATCHES_PKG dependencies on GHG_TRANSACTION_DETAILS_ALL

Line 170: DELETE FROM GHG_TRANSACTION_DETAILS_ALL a

166:
167: DELETE FROM GHG_TRANSACTIONS_ALL
168: WHERE transaction_batch_id = x_transaction_batch_id;
169:
170: DELETE FROM GHG_TRANSACTION_DETAILS_ALL a
171: WHERE not exists (select 1
172: from GHG_TRANSACTIONS_ALL b
173: where a.transaction_id = b.transaction_id);
174: