APPS.MSC_DEMAND_PKG dependencies on DUAL

Line 106: select msc_hub_query_s.nextval into l_qid_vmi from dual;

102: l_stmt_id :=10;
103: ----------------------------------------------------
104:
105:
106: select msc_hub_query_s.nextval into l_qid_vmi from dual;
107:
108: insert into msc_hub_query(
109:
110: query_id,

Line 987: select msc_hub_query_s.nextval into l_qid_last_date from dual;

983:
984:
985:
986: l_stmt_id :=30;
987: select msc_hub_query_s.nextval into l_qid_last_date from dual;
988:
989: insert into msc_hub_query (
990: query_id,
991: last_update_date,

Line 1011: from dual

1007: from msc_phub_fiscal_periods_mv bp
1008: where bp.end_date between l_first_bkt_start_date and l_last_bkt_end_date
1009: union
1010: select l_qid_last_date, l_sysdate, 1, l_sysdate, 1, 1, trunc(l_last_bkt_end_date)
1011: from dual
1012: order by 1;
1013:
1014: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' last_date=' || l_qid_last_date);
1015: commit;

Line 1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;

1017:
1018:
1019:
1020: l_stmt_id :=40;
1021: select msc_hub_query_s.nextval into l_qid_demand_date from dual;
1022:
1023:
1024: insert into msc_hub_query (
1025: query_id,

Line 1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;

1043: commit;
1044:
1045:
1046: l_stmt_id :=45;
1047: select msc_hub_query_s.nextval into l_qid_demand_item from dual;
1048: insert into msc_hub_query (
1049: query_id,
1050: last_update_date,
1051: last_updated_by,

Line 1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;

1095:
1096:
1097:
1098: l_stmt_id :=50;
1099: select msc_hub_query_s.nextval into l_qid_dl_relation from dual;
1100:
1101: insert into msc_hub_query (
1102: query_id,
1103: last_update_date,