DBA Data[Home] [Help]

APPS.MSC_SATP_FUNC dependencies on MSC_REGION_LOCATIONS

Line 2518: from msc_region_locations

2514: region_id,
2515: region_type,
2516: 'N',
2517: l_customer_type
2518: from msc_region_locations
2519: where location_id in (
2520: select location_id
2521: from msc_tp_site_id_lid tpsid
2522: where tpsid.sr_instance_id = p_instance_id

Line 2540: from msc_region_locations mrl,

2536: mrl.region_id,
2537: mrl.region_type,
2538: 'N',
2539: l_customer_type
2540: from msc_region_locations mrl,
2541: msc_tp_site_id_lid tpsid
2542:
2543: where mrl.location_id = tpsid.location_id
2544: and tpsid.sr_instance_id = p_instance_id

Line 2876: from msc_region_locations

2872: if (nvl(p_calling_module,-99) = 724) then
2873:
2874: select 1
2875: into l_temp_var
2876: from msc_region_locations
2877: where sr_instance_id = p_instance_id
2878: and rownum = 1;
2879:
2880: else