APPS.GHG_TRANSACTION_BATCHES_PKG dependencies on GHG_TRANSACTIONS_V

Line 431: FROM GHG_TRANSACTIONS_V

427: x_last_update_login,
428: emission_scope_lookup_code,
429: location_code,
430: measurement_criteria
431: FROM GHG_TRANSACTIONS_V
432: WHERE transaction_batch_id = x_copy_transaction_batch_id;
433:
434: COMMIT;
435:

Line 436: FOR calc_emissions IN (SELECT transaction_id from ghg_transactions_v where

432: WHERE transaction_batch_id = x_copy_transaction_batch_id;
433:
434: COMMIT;
435:
436: FOR calc_emissions IN (SELECT transaction_id from ghg_transactions_v where
437: transaction_batch_id = x_transaction_batch_id)
438: LOOP
439: GHG_EMISSION_RATES_PKG.calculate_emissions(calc_emissions.transaction_id);
440: END LOOP;

Line 565: FROM GHG_TRANSACTIONS_V

561: x_last_update_login,
562: emission_scope_lookup_code,
563: location_code,
564: measurement_criteria
565: FROM GHG_TRANSACTIONS_V
566: WHERE transaction_batch_id = x_reversed_transact_batch_id;
567:
568: COMMIT;
569:

Line 570: FOR calc_emissions IN (SELECT transaction_id from GHG_transactions_v where

566: WHERE transaction_batch_id = x_reversed_transact_batch_id;
567:
568: COMMIT;
569:
570: FOR calc_emissions IN (SELECT transaction_id from GHG_transactions_v where
571: transaction_batch_id = x_transaction_batch_id)
572: LOOP
573: GHG_EMISSION_RATES_PKG.calculate_emissions(calc_emissions.transaction_id);
574: END LOOP;