APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_LOCATIONS_ALL

Line 877: FROM pn_locations_all

873: l_location_code VARCHAR2 (90);
874: BEGIN
875: SELECT location_code
876: INTO l_location_code
877: FROM pn_locations_all
878: WHERE location_id = p_location_id
879: AND ROWNUM < 2;
880: RETURN l_location_code ;
881: EXCEPTION