APPS.MSC_WS_COMMON dependencies on MSC_PLAN_ORGANIZATIONS

Line 302: msc_plan_organizations

298: -- its not allow to add organization to the plan in the set plan option
299: SELECT
300: sr_instance_id INTO InsId
301: FROM
302: msc_plan_organizations
303: WHERE
304: plan_id = PlanId AND
305: organization_id = OrgId;
306: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1003: msc_plan_organizations_v mpo

999: SELECT
1000: desig.designator_type
1001: FROM
1002: msc_designators desig,
1003: msc_plan_organizations_v mpo
1004: WHERE
1005: desig.designator_type not in (1,6) AND
1006: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND
1007: mpo.organization_id = desig.organization_id AND