APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_ST_NET_RESOURCE_AVAIL

Line 2221: FROM msc_st_net_resource_avail msnra

2217: msnra.shift_date,
2218: msnra.from_time,
2219: msnra.to_time,
2220: msnra.capacity_units
2221: FROM msc_st_net_resource_avail msnra
2222: WHERE msnra.sr_instance_id = MSC_CL_COLLECTION.v_instance_id and
2223: msnra.organization_id=org_id;
2224:
2225:

Line 2354: ||' FROM msc_st_net_resource_avail msnra'

2350: ||' :v_current_user,'
2351: ||' :v_current_date,'
2352: ||' :v_current_user,'
2353: ||' :v_last_collection_id'
2354: ||' FROM msc_st_net_resource_avail msnra'
2355: ||' WHERE msnra.sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2356: ||' AND msnra.organization_id = ' ||c_rec1.organization_id;
2357:
2358: EXECUTE IMMEDIATE lv_sql_stmt