DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_LOCATION_ASSOCIATIONS

Line 428: from msc_location_associations

424: arg_org_id = -1 ) and
425: arg_location_id is not NULL THEN
426: select location_code
427: into loc_code
428: from msc_location_associations
429: where location_id = arg_location_id
430: and sr_instance_id = arg_instance_id;
431: ELSE
432: select location