[Home] [Help]
APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on PN_LOCATIONS_ALL
Line 644: from pn_locations_all
640: begin
641:
642: select active_start_date, active_end_date, parent_location_id
643: into l_start_date_active, l_end_date_active, l_parent_location_id
644: from pn_locations_all
645: where location_id = asset_rec.pn_location_id
646: and active_start_date <= sysdate
647: and active_end_date >= sysdate;
648: