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
26: and ( mai.lrtype in ('C','P')
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
207: and ( mai.lrtype in ('C','P')