DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_COPY_PKG dependencies on DUAL

Line 652: -- Changing SYS.DUAL to DUAL as this is the correct coding standard

648: IS
649: CURSOR C1 IS
650: -- anagarwa Tue Dec 24 11:44:52 PST 2002
651: -- Bug 2725466
652: -- Changing SYS.DUAL to DUAL as this is the correct coding standard
653: -- The code may fail in databases that do not have SYS schema
654: SELECT 1 FROM DUAL
655: WHERE NOT EXISTS
656: (SELECT 1 FROM qa_plans

Line 654: SELECT 1 FROM DUAL

650: -- anagarwa Tue Dec 24 11:44:52 PST 2002
651: -- Bug 2725466
652: -- Changing SYS.DUAL to DUAL as this is the correct coding standard
653: -- The code may fail in databases that do not have SYS schema
654: SELECT 1 FROM DUAL
655: WHERE NOT EXISTS
656: (SELECT 1 FROM qa_plans
657: WHERE translate(substr(upper(name),1,25),' ''','__') =
658: translate(substr(upper(p_plan_name),1,25),' ''','__'));