DBA Data[Home] [Help]

APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on PN_LOCATIONS_ALL

Line 638: from pn_locations_all

634: begin
635:
636: select active_start_date, active_end_date, parent_location_id
637: into l_start_date_active, l_end_date_active, l_parent_location_id
638: from pn_locations_all
639: where location_id = asset_rec.pn_location_id
640: and active_start_date <= sysdate
641: and active_end_date >= sysdate;
642: