APPS.GHG_TRANSACTIONS_PKG dependencies on GHG_UTILITIES_PKG

Line 932: and trunc(P_TRANS_DATE) between start_date and nvl(end_date,GHG_UTILITIES_PKG.end_date);

928: select location_description
929: into v_facility
930: from ghg_assets_v
931: where asset_number = p_trans_source
932: and trunc(P_TRANS_DATE) between start_date and nvl(end_date,GHG_UTILITIES_PKG.end_date);
933:
934:
935: vl_debug := 'Org :'||v_org_id;
936:

Line 1026: AND NVL(xnir.end_date, GHG_UTILITIES_PKG.end_date)

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)
1027: AND xna.asset_number = p_asset_num
1028: AND xna.transport_type_lookup_code = xnir.transport_type_lookup_code;
1029:
1030: RETURN vl_item_number;