DBA Data[Home] [Help]

APPS.GHG_EMISSION_RATES_PKG dependencies on GHG_EMISSION_FORMULAS

Line 811: , ghg_emission_formulas ef

807: select decode(x_uom_class, fnd_profile.value('GHG_UOM_CLASS'), nvl(ef.secondary_formula_id,ef.formula_id), ef.formula_id)
808: into vl_formula_id
809: from ghg_sources s
810: , ghg_source_combinations_all f
811: , ghg_emission_formulas ef
812: where s.source_id = f.source_id
813: and f.source_combination_id = x_factor_id
814: and s.formula_id = ef.formula_id;
815:

Line 820: from ghg_emission_formulas

816: -- dbms_output.put_line('In create_ledger_entry:get formula'||':'||x_emission_id);
817:
818: select 'select '||formula_content||' from dual'
819: into vl_formula_contents
820: from ghg_emission_formulas
821: where formula_id = vl_formula_id;
822:
823: -- Get the Value of EC
824: BEGIN