DBA Data[Home] [Help]

APPS.MSC_PLAN_RELEASE dependencies on MSC_COLL_PARAMETERS

Line 22: msc_coll_parameters mcp

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')

Line 203: msc_coll_parameters mcp

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')