APPS.MSC_GET_GANTT_DATA dependencies on DUAL

Line 3119: from dual;

3115: where query_id = g_find_query_id;
3116: else
3117: select msc_form_query_s.nextval
3118: into g_find_query_id
3119: from dual;
3120: end if;
3121: OPEN resource_cursor FOR sql_statement
3122: USING p_plan_id;
3123:

Line 3992: from dual;

3988: if g_end_demand_id is not null then
3989:
3990: select msc_form_query_s.nextval
3991: into p_end_peg_query_id
3992: from dual;
3993:
3994: insert into msc_form_query
3995: (QUERY_ID,
3996: LAST_UPDATE_DATE,

Line 4050: from dual;

4046:
4047: if p_op_seq_query_id is null then
4048: select msc_form_query_s.nextval
4049: into p_op_seq_query_id
4050: from dual;
4051: end if;
4052: if p_critical <> -1 then
4053: insert into msc_form_query
4054: (QUERY_ID,

Line 4164: from dual;

4160:
4161: if p_query_id is null then
4162: select msc_form_query_s.nextval
4163: into p_query_id
4164: from dual;
4165: end if;
4166:
4167: -- get the end_pegging_id
4168: if g_end_demand_id is null then

Line 4172: from dual;

4168: if g_end_demand_id is null then
4169:
4170: select msc_form_query_s.nextval
4171: into p_end_peg_query_id
4172: from dual;
4173:
4174: insert into msc_form_query
4175: (QUERY_ID,
4176: LAST_UPDATE_DATE,

Line 5038: from dual;

5034: where query_id = g_supply_query_id;
5035: else
5036: select msc_form_query_s.nextval
5037: into g_supply_query_id
5038: from dual;
5039: end if;
5040:
5041: if g_res_query_id is not null then
5042: delete msc_form_query

Line 5047: from dual;

5043: where query_id = g_res_query_id;
5044: else
5045: select msc_form_query_s.nextval
5046: into g_res_query_id
5047: from dual;
5048: end if;
5049:
5050: g_supplier_query_id := null;
5051:

Line 5833: from dual;

5829: where query_id = g_supply_query_id;
5830: else
5831: select msc_form_query_s.nextval
5832: into g_supply_query_id
5833: from dual;
5834: end if;
5835: -- for resource centric view
5836: if g_res_query_id is not null then
5837: delete msc_form_query

Line 5842: from dual;

5838: where query_id = g_res_query_id;
5839: else
5840: select msc_form_query_s.nextval
5841: into g_res_query_id
5842: from dual;
5843: end if;
5844: -- for supplier list
5845: if g_supplier_query_id is not null then
5846: delete msc_form_query

Line 5851: from dual;

5847: where query_id = g_supplier_query_id;
5848: else
5849: select msc_form_query_s.nextval
5850: into g_supplier_query_id
5851: from dual;
5852: end if;
5853:
5854: i :=the_index;
5855: OPEN end_demand_cur;