APPS.MSC_PLAN_RELEASE dependencies on MSC_APPS_INSTANCES

Line 21: from msc_apps_instances mai,

17: where plan_id=p_plan_id;
18:
19: cursor check_coll_cur is
20: select nvl(mai.st_status,0)
21: from msc_apps_instances mai,
22: msc_coll_parameters mcp
23: where mai.instance_id = p_plan_inst_id
24: and mai.instance_id = mcp.instance_id
25: and nvl(mai.st_status,0) > 0

Line 202: from msc_apps_instances mai,

198: where plan_id=p_plan_id;
199:
200: cursor check_coll_cur is
201: select nvl(mai.st_status,0)
202: from msc_apps_instances mai,
203: msc_coll_parameters mcp
204: where mai.instance_id = p_plan_inst_id
205: and mai.instance_id = mcp.instance_id
206: and nvl(mai.st_status,0) > 0

Line 221: msc_apps_instances mai

217: CURSOR cur_supply_order IS
218: SELECT sum(decode(ms.load_type,20,0,1)),
219: sum(decode(ms.load_type,20,1,0))
220: FROM msc_supplies ms,
221: msc_apps_instances mai
222: where ms.plan_id = pid
223: and ms.release_errors is null
224: and ms.load_type is not null
225: and ms.sr_instance_id = mai.instance_id

Line 599: from msc_apps_instances

595: select decode(apps_ver,3,nvl(allow_release_flag ,2)
596: ,4,nvl(allow_release_flag ,2)
597: ,1) allow_release_flag,
598: instance_code
599: from msc_apps_instances
600: where instance_id = nvl(p_sr_instance_id,-1);
601: begin
602: open cur_release_flag;
603: fetch cur_release_flag