APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_NET_RESOURCE_AVAIL_S

Line 246: msc_net_resource_avail_s.NEXTVAL

242: program_id,
243: program_update_date,
244: refresh_number)
245: VALUES(
246: msc_net_resource_avail_s.NEXTVAL
247: , -1
248: ,var_department_id
249: ,var_resource_id
250: ,var_organization_id

Line 404: SELECT msc_net_resource_avail_s.NEXTVAL

400: request_id,
401: program_application_id,
402: program_id,
403: program_update_date)
404: SELECT msc_net_resource_avail_s.NEXTVAL
405: ,-1
406: ,arg_organization_id
407: ,arg_sr_instance_id
408: ,arg_department_id

Line 469: SELECT msc_net_resource_avail_s.NEXTVAL

465: request_id,
466: program_application_id,
467: program_id,
468: program_update_date)
469: SELECT msc_net_resource_avail_s.NEXTVAL
470: ,-1
471: ,arg_organization_id
472: ,arg_sr_instance_id
473: ,arg_department_id

Line 598: VALUES( msc_net_resource_avail_s.NEXTVAL

594: request_id,
595: program_application_id,
596: program_id,
597: program_update_date)
598: VALUES( msc_net_resource_avail_s.NEXTVAL
599: ,-1
600: ,arg_organization_id
601: ,arg_sr_instance_id
602: ,arg_department_id

Line 695: VALUES( msc_net_resource_avail_s.NEXTVAL

691: request_id,
692: program_application_id,
693: program_id,
694: program_update_date)
695: VALUES( msc_net_resource_avail_s.NEXTVAL
696: ,-1
697: ,arg_organization_id
698: ,arg_sr_instance_id
699: ,arg_department_id

Line 1138: SELECT msc_net_resource_avail_s.NEXTVAL

1134: program_application_id,
1135: program_id,
1136: program_update_date,
1137: refresh_number)
1138: SELECT msc_net_resource_avail_s.NEXTVAL
1139: ,-1
1140: ,arg_organization_id
1141: ,arg_sr_instance_id
1142: ,arg_department_id

Line 1624: msc_net_resource_avail_s.NEXTVAL

1620: program_id,
1621: program_update_date,
1622: refresh_number)
1623: SELECT /*+ leading(line) INDEX(LINE) use_nl(dates) */
1624: msc_net_resource_avail_s.NEXTVAL
1625: ,-1
1626: ,arg_organization_id
1627: ,arg_sr_instance_id
1628: ,line.department_id

Line 1692: msc_net_resource_avail_s.NEXTVAL

1688: program_id,
1689: program_update_date,
1690: refresh_number)
1691: SELECT /*+ leading(line) INDEX(LINE) use_nl(dates) */
1692: msc_net_resource_avail_s.NEXTVAL
1693: ,-1
1694: ,arg_organization_id
1695: ,arg_sr_instance_id
1696: ,line.department_id

Line 2346: ||' msc_net_resource_avail_s.NEXTVAL,'

2342: ||' creation_date,'
2343: ||' created_by,'
2344: ||' refresh_number)'
2345: ||' SELECT'
2346: ||' msc_net_resource_avail_s.NEXTVAL,'
2347: ||' -1,'
2348: ||' msnra.department_id,'
2349: ||' msnra.resource_id,'
2350: ||' msnra.organization_id,'

Line 2421: msc_net_resource_avail_s.NEXTVAL,

2417: creation_date,
2418: created_by,
2419: refresh_number)
2420: VALUES(
2421: msc_net_resource_avail_s.NEXTVAL,
2422: -1,
2423: c_rec.department_id,
2424: c_rec.resource_id,
2425: c_rec.organization_id,