APPS.MSC_PHUB_EXCESS_PKG dependencies on DUAL

Line 61: select msc_hub_query_s.nextval into l_qid_eo from dual;

57: 'l_item_simulation_set_id='||l_item_simulation_set_id||', '||
58: 'l_sim_plan_id='||l_sim_plan_id);
59:
60: if l_item_simulation_set_id is not null then
61: select msc_hub_query_s.nextval into l_qid_eo from dual;
62: insert into msc_hub_query(
63: query_id,
64: last_update_date,
65: last_updated_by,

Line 100: from dual;

96: else
97: if (l_plan_type=6) then
98: select fnd_profile.value('MSC_APCC_SNO_ITEM_SIMULATION_SET')
99: into l_item_simulation_set_id
100: from dual;
101: else
102: select item_simulation_set_id
103: into l_item_simulation_set_id
104: from msc_plans

Line 112: select msc_hub_query_s.nextval into l_qid_eo from dual;

108: msc_phub_util.log('msc_phub_excess_pkg.populate_details: '||
109: 'l_item_simulation_set_id='||l_item_simulation_set_id);
110:
111: if l_item_simulation_set_id is not null then
112: select msc_hub_query_s.nextval into l_qid_eo from dual;
113: insert into msc_hub_query(
114: query_id,
115: last_update_date,
116: last_updated_by,