APPS.GHG_EMISSION_RATES_PKG dependencies on GHG_TRANSACTIONS_ALL

Line 180: from GHG_transactions_all

176: v_facility_id,
177: v_source_id,
178: v_uom,
179: v_org_id
180: from GHG_transactions_all
181: where transaction_id = x_emission_id;
182:
183: -- dbms_output.put_line('Create Emissions: Get UOM :');
184: -- Get UOM Class off Unit Of Measure..

Line 213: update GHG_transactions_all

209: create_ledger_entry ( x_emission_id, v_emission_factor_id, v_emission_quantity*nvl(v_uom_conversion,1),v_emission_date_from+days, v_uom_class,v_org_id);
210:
211: end loop;
212:
213: update GHG_transactions_all
214: set emission_quantity = GHG_transactions_pkg.get_emission_total(x_emission_id)
215: , energy_quantity = GHG_transactions_pkg.get_energy_total(x_emission_id)
216: , emission_SCOPE_LOOKUP_CODE =
217: (SELECT decode(emission_SCOPE_LOOKUP_CODE,