APPS.MSC_SUPPLIER_PKG dependencies on DUAL

Line 90: select msc_hub_query_s.nextval into l_qid_req from dual;

86: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
87: --dbms_output.put_line('populate_details '||p_plan_id||', '||p_plan_run_id||', '||l_plan_type);
88:
89: l_stmt_id:=10;
90: select msc_hub_query_s.nextval into l_qid_req from dual;
91: insert into msc_hub_query(
92: query_id,
93: last_update_date,
94: last_updated_by,

Line 283: select msc_hub_query_s.nextval into l_qid_avail_org from dual;

279: commit;
280:
281:
282: l_stmt_id:=20;
283: select msc_hub_query_s.nextval into l_qid_avail_org from dual;
284: insert into msc_hub_query(
285: query_id,
286: last_update_date,
287: last_updated_by,

Line 394: select msc_hub_query_s.nextval into l_qid_avail_req from dual;

390: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' l_qid_avail_org=' || l_qid_avail_org);
391: commit;
392:
393: l_stmt_id:=30;
394: select msc_hub_query_s.nextval into l_qid_avail_req from dual;
395: insert into msc_hub_query(
396: query_id,
397: last_update_date,
398: last_updated_by,

Line 467: select msc_hub_query_s.nextval into l_qid_avail_cum from dual;

463: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' l_qid_avail_req=' || l_qid_avail_req);
464: commit;
465:
466: l_stmt_id:=40;
467: select msc_hub_query_s.nextval into l_qid_avail_cum from dual;
468: insert into msc_hub_query(
469: query_id,
470: last_update_date,
471: last_updated_by,