APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PN_LOCATIONS_ALL

Line 332: FROM pn_locations_all loc,

328: loc.last_updated_by last_updated_by,
329: loc.last_update_login last_update_login,
330: loc.creation_date creation_date,
331: loc.created_by created_by
332: FROM pn_locations_all loc,
333: fnd_lookups fl,
334: fnd_lookups fl1
335: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
336: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'

Line 343: AND loc.location_id IN (SELECT loc.location_id from pn_locations_all loc

339: and nvl(trunc(as_of_date),trunc(loc.active_start_date)) between
340: trunc(loc.active_start_date) and trunc(loc.active_end_date);
341: /* Bug 4748773
342:
343: AND loc.location_id IN (SELECT loc.location_id from pn_locations_all loc
344: WHERE loc.active_start_date <= as_of_date
345: AND loc.active_end_date >= as_of_date
346: AND loc.location_id = v_location_id_1);
347: */

Line 665: FROM pn_locations_all loc,

661: loc.last_updated_by last_updated_by,
662: loc.last_update_login last_update_login,
663: loc.creation_date creation_date,
664: loc.created_by created_by
665: FROM pn_locations_all loc,
666: fnd_lookups fl,
667: fnd_lookups fl1
668: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
669: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'

Line 675: AND loc.location_id IN (SELECT loc.location_id from pn_locations_all loc

671: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'
672: and nvl(trunc(as_of_date),trunc(loc.active_start_date)) between
673: trunc(loc.active_start_date) and trunc(loc.active_end_date);
674: /* Bug 4748773
675: AND loc.location_id IN (SELECT loc.location_id from pn_locations_all loc
676: WHERE loc.active_start_date <= as_of_date
677: AND loc.active_end_date >= as_of_date
678: AND loc.location_id = v_location_id_1 );
679: */