APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_ST_NET_RESOURCE_AVAIL

Line 2233: FROM msc_st_net_resource_avail msnra

2229: msnra.shift_date,
2230: msnra.from_time,
2231: msnra.to_time,
2232: msnra.capacity_units
2233: FROM msc_st_net_resource_avail msnra
2234: WHERE msnra.sr_instance_id = MSC_CL_COLLECTION.v_instance_id and
2235: msnra.organization_id=org_id;
2236:
2237:

Line 2366: ||' FROM msc_st_net_resource_avail msnra'

2362: ||' :v_current_user,'
2363: ||' :v_current_date,'
2364: ||' :v_current_user,'
2365: ||' :v_last_collection_id'
2366: ||' FROM msc_st_net_resource_avail msnra'
2367: ||' WHERE msnra.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2368: ||' AND msnra.organization_id = ' ||c_rec1.organization_id;
2369:
2370: EXECUTE IMMEDIATE lv_sql_stmt