DBA Data[Home] [Help]

APPS.MSC_WS_COMMON dependencies on MSC_DESIGNATORS

Line 258: msc_designators desig

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

Line 990: msc_designators

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

Line 1002: msc_designators desig,

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