APPS.MSC_GET_NAME dependencies on MSC_LOCATION_ASSOCIATIONS

Line 322: from msc_location_associations

318: arg_org_id = -1 ) and
319: arg_location_id is not NULL THEN
320: select location_code
321: into loc_code
322: from msc_location_associations
323: where location_id = arg_location_id
324: and sr_instance_id = arg_instance_id;
325: ELSE
326: select location