APPS.GHG_PO_EMISSIONS_PKG dependencies on GHG_SYSTEM_PARAMETERS_V

Line 24: v_po_match_emission_date GHG_SYSTEM_PARAMETERS_V.po_match_emission_date%TYPE;

20: v_map_accounts_flag GHG_SEGMENT_MAPPINGS_V.map_accounts_flag%TYPE;
21: v_map_operating_unit_flag GHG_SEGMENT_MAPPINGS_V.map_operating_unit_flag%TYPE;
22: v_map_projects_flag GHG_SEGMENT_MAPPINGS_V.map_projects_flag%TYPE;
23: v_facility_id_for_op_unit NUMBER(15) := NULL;
24: v_po_match_emission_date GHG_SYSTEM_PARAMETERS_V.po_match_emission_date%TYPE;
25: v_receipt_match_emission_date GHG_SYSTEM_PARAMETERS_V.receipt_match_emission_date%TYPE;
26: v_emission_date DATE;
27: v_highest_emission_number NUMBER(15);
28: v_facility_id NUMBER(15);

Line 25: v_receipt_match_emission_date GHG_SYSTEM_PARAMETERS_V.receipt_match_emission_date%TYPE;

21: v_map_operating_unit_flag GHG_SEGMENT_MAPPINGS_V.map_operating_unit_flag%TYPE;
22: v_map_projects_flag GHG_SEGMENT_MAPPINGS_V.map_projects_flag%TYPE;
23: v_facility_id_for_op_unit NUMBER(15) := NULL;
24: v_po_match_emission_date GHG_SYSTEM_PARAMETERS_V.po_match_emission_date%TYPE;
25: v_receipt_match_emission_date GHG_SYSTEM_PARAMETERS_V.receipt_match_emission_date%TYPE;
26: v_emission_date DATE;
27: v_highest_emission_number NUMBER(15);
28: v_facility_id NUMBER(15);
29: v_emission_id NUMBER(15);

Line 151: FROM GHG_SYSTEM_PARAMETERS_V xnsp;

147: SELECT xnsp.po_match_emission_date,
148: xnsp.receipt_match_emission_date
149: INTO v_po_match_emission_date,
150: v_receipt_match_emission_date
151: FROM GHG_SYSTEM_PARAMETERS_V xnsp;
152:
153: v_debug_info := 'Get item emission line number';
154:
155: -- Determine the last emission line number for the current invoice.