APPS.EAM_PN_EXTRACTION_PUB dependencies on PN_LOCATIONS_ALL

Line 154: from pn_locations_all pl

150: x_insert_status := 4;
151:
152: select pl.active_start_date, pl.active_end_date
153: into l_pn_start_date, l_pn_end_date
154: from pn_locations_all pl
155: where location_id = p_pn_location_id;
156:
157: -- Bug # 3372982
158: SELECT COUNT(*)