APPS.MSC_GET_NAME dependencies on MSC_REGIONS

Line 3783: from msc_regions

3779: l_zone_name varchar2(255) ;
3780:
3781: cursor cur_zone(l_zone_id number , l_sr_instance_id number) is
3782: select zone
3783: from msc_regions
3784: where region_id = l_zone_id
3785: and region_type = 10
3786: and sr_instance_id = l_sr_instance_id ;
3787:

Line 3790: from msc_regions

3786: and sr_instance_id = l_sr_instance_id ;
3787:
3788: cursor global_zone is
3789: select zone
3790: from msc_regions
3791: where region_id = p_zone_id
3792: and region_type = 10;
3793:
3794: l_key varchar2(50);