254: InsId,
255: PlanName
256: FROM
257: msc_plans plans,
258: msc_designators desig
259: WHERE
260: plans.organization_id = desig.organization_id AND
261: plans.sr_instance_id = desig.sr_instance_id AND
262: plans.compile_designator = desig.designator AND
986: BEGIN
987: SELECT
988: designator_type INTO DesigType
989: FROM
990: msc_designators
991: WHERE
992: trunc(nvl(disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND
993: designator <> PlanName AND
994: organization_id = OrgId AND
998: UNION
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