APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on PN_LOCATIONS_ALL

Line 318: FROM pn_locations_all loc,

314: loc.last_updated_by LAST_UPDATED_BY,
315: loc.last_update_login LAST_UPDATE_LOGIN,
316: loc.creation_date CREATION_DATE,
317: loc.created_by CREATED_BY
318: FROM pn_locations_all loc,
319: fnd_lookups fl,
320: fnd_lookups fl1
321: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
322: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'

Line 325: AND loc.location_id IN (SELECT loc.location_id FROM pn_locations_all loc

321: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
322: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
323: AND fl1.lookup_code(+)= loc.location_type_lookup_code
324: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'
325: AND loc.location_id IN (SELECT loc.location_id FROM pn_locations_all loc
326: WHERE active_start_date <= as_of_date
327: AND active_end_date >= as_of_date
328: START WITH loc.location_id = V_LOCATION_ID_1
329: CONNECT BY PRIOR loc.location_id = loc.parent_location_id

Line 692: FROM pn_locations_all loc,

688: loc.last_updated_by LAST_UPDATED_BY,
689: loc.last_update_login LAST_UPDATE_LOGIN,
690: loc.creation_date CREATION_DATE,
691: loc.created_by CREATED_BY
692: FROM pn_locations_all loc,
693: fnd_lookups fl,
694: fnd_lookups fl1
695: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
696: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'

Line 699: AND loc.location_id in (select loc.location_id FROM pn_locations_all loc

695: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
696: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
697: AND fl1.lookup_code(+)= loc.location_type_lookup_code
698: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'
699: AND loc.location_id in (select loc.location_id FROM pn_locations_all loc
700: WHERE active_start_date <= as_of_date
701: AND active_end_date >= as_of_date
702: START WITH loc.location_id = V_LOCATION_ID_1
703: CONNECT BY PRIOR loc.location_id = loc.parent_location_id