APPS.MSC_RESOURCE_PKG dependencies on MSC_HUB_QUERY

Line 47: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);

43: delete from msc_resources_f
44: where plan_id = p_plan_id
45: and plan_run_id = p_plan_run_id
46: and (p_plan_id, sr_instance_id, organization_id, department_id, resource_id) in
47: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);
48:
49: l_rowcount1 := l_rowcount1 + sql%rowcount;
50: msc_phub_util.log('msc_resources_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
51:

Line 57: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);

53: delete from msc_resources_cum_f
54: where plan_id = p_plan_id
55: and plan_run_id = p_plan_run_id
56: and (p_plan_id, sr_instance_id, organization_id, department_id, resource_id) in
57: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);
58:
59: l_rowcount2 := l_rowcount2 + sql%rowcount;
60: msc_phub_util.log('msc_resources_cum_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);
61: commit;

Line 129: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid)))

125: or (p_plan_id = -1
126: and mdr.sr_instance_id = l_sr_instance_id
127: and (l_refresh_mode = 1
128: or (l_refresh_mode = 2 and (p_plan_id, mdr.sr_instance_id, mdr.organization_id, mdr.department_id, mdr.resource_id) in
129: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid)))
130: )
131: )
132: group by
133: mrr.sr_instance_id,

Line 187: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid) ) )

183: or (p_plan_id = -1
184: and mra.simulation_set is null
185: and (l_refresh_mode = 1
186: or (l_refresh_mode = 2 and (p_plan_id, mra.sr_instance_id, mra.organization_id, mra.department_id, mra.resource_id) in
187: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid) ) )
188: )
189: )
190: group by
191: mra.sr_instance_id,

Line 474: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid)))

470: or (f.plan_id = -1
471: and f.sr_instance_id = l_sr_instance_id
472: and (l_refresh_mode = 1
473: or (l_refresh_mode = 2 and (p_plan_id, f.sr_instance_id, f.organization_id, f.department_id, f.resource_id) in
474: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid)))
475: )
476: )
477: group by
478: f.plan_id,