APPS.GHG_TRANSACTIONS_PKG dependencies on GHG_ITEM_FACTORS_V

Line 1022: FROM GHG_item_factors_v xnir,

1018: vl_item_number VARCHAR2(50);
1019: BEGIN
1020: SELECT min(xnir.inventory_item)
1021: into vl_item_number
1022: FROM GHG_item_factors_v xnir,
1023: GHG_assets xna
1024: WHERE xnir.item_type_lookup_code = 'I'
1025: AND sysdate BETWEEN NVL(xnir.start_date, sysdate - 1)
1026: AND NVL(xnir.end_date, GHG_UTILITIES_PKG.end_date)