DBA Data[Home] [Help]

APPS.MSC_PLAN_RELEASE dependencies on MSC_PLANS

Line 16: from msc_plans

12: collection_status number;
13:
14: cursor cur_plan_info is
15: select organization_id,sr_instance_id,compile_designator
16: from msc_plans
17: where plan_id=p_plan_id;
18:
19: cursor check_coll_cur is
20: select nvl(mai.st_status,0)

Line 197: from msc_plans

193: l_sr_instance_id number;
194:
195: cursor cur_plan_info is
196: select organization_id,sr_instance_id,compile_designator
197: from msc_plans
198: where plan_id=p_plan_id;
199:
200: cursor check_coll_cur is
201: select nvl(mai.st_status,0)