APPS.GHG_EMISSION_RATES_PKG dependencies on GHG_SOURCE_COMBINATIONS_ALL

Line 19: from GHG_source_combinations_all

15: v_max_date date;
16: BEGIN
17: select max(nvl(end_date+1,start_date)) --ssurendr: Changed GHG_UTILITIES_PKG.end_date to start_date so that duplicate record validation correctly happens.
18: into v_max_date
19: from GHG_source_combinations_all
20: where /*code_combination_id = x_code_combination_id --Lakshmi 04/27/11 - nvl is removed so that correct start date is returned.
21: ssurendr 05/06 - code combination removed from join
22: and*/ source_id = x_emission_source_id
23: and nvl(supplier_id, -1) = nvl(x_supplier_id, -1)

Line 48: from GHG_source_combinations_all

44: v_count number;
45: BEGIN
46: select count(*)
47: into v_count
48: from GHG_source_combinations_all
49: where code_combination_id = x_code_combination_id
50: and source_id = x_emission_source_id
51: and nvl(supplier_id,-1) = nvl(x_supplier_id,-1)
52: and nvl(supplier_site_id,-1) = nvl(x_supplier_site_id,-1)

Line 220: FROM GHG_source_combinations_all

216: , emission_SCOPE_LOOKUP_CODE =
217: (SELECT decode(emission_SCOPE_LOOKUP_CODE,
218: '-99999', SCOPE_LOOKUP_CODE,
219: emission_SCOPE_LOOKUP_CODE)
220: FROM GHG_source_combinations_all
221: where SOURCE_COMBINATION_ID=v_emission_factor_id)
222: where transaction_id = x_emission_id;
223:
224:

Line 302: FROM GHG_source_combinations_all

298: x_out_location -- 12565482 : ssurendr
299: FROM
300: (SELECT source_combination_id,
301: location_code -- 12565482 : ssurendr
302: FROM GHG_source_combinations_all
303: WHERE source_id = x_source_id
304: AND scope_lookup_code = decode(x_scope,
305: '-99999', scope_lookup_code,
306: null, scope_lookup_code,

Line 626: FROM GHG_source_combinations_all

622: x_out_location -- 12565482 : ssurendr
623: FROM
624: (SELECT source_combination_id,
625: location_code -- 12565482 : ssurendr
626: FROM GHG_source_combinations_all
627: WHERE source_id = x_source_id
628: AND scope_lookup_code = decode(x_scope,
629: '-99999', scope_lookup_code,
630: null, scope_lookup_code,

Line 810: , ghg_source_combinations_all f

806:
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;