APPS.MSC_WS_PLAN_MANAGEMENT dependencies on MSC_PLANS

Line 29: msc_plans plans,

25: l_OrgId,
26: l_InsId,
27: l_PlanName
28: FROM
29: msc_plans plans,
30: msc_designators desig
31: WHERE
32: plans.organization_id = desig.organization_id AND
33: plans.sr_instance_id = desig.sr_instance_id AND

Line 74: msc_plans plans

70: BEGIN
71: BEGIN
72: SELECT 1 INTO l_Dummy
73: FROM
74: msc_plans plans
75: WHERE
76: plans.organization_id = OrgId AND
77: plans.sr_instance_id = InsId AND
78: plans.compile_designator = PlanName;

Line 162: msc_plans plans,

158: BEGIN
159: SELECT NVL(archive_flag, 2)
160: INTO ArchiveFlag
161: FROM
162: msc_plans plans,
163: msc_designators desig
164: WHERE
165: plans.organization_id = desig.organization_id AND
166: plans.sr_instance_id = desig.sr_instance_id AND

Line 267: FROM msc_plans

263: l_DestOrgSelection := GET_DEST_ORG_SELECTION(l_OrgId, l_InsId, l_SrcPlanName);
264:
265: BEGIN
266: SELECT curr_plan_type INTO l_PlanType
267: FROM msc_plans
268: WHERE plan_id = SrcPlanId;
269: EXCEPTION WHEN others THEN
270: g_ErrorCode := 'ERROR_UNEXPECTED_00005';
271: raise;