APPS.PA_PROJ_STRUCTURE_PUB dependencies on DUAL

Line 653: FROM DUAL

649: -- Start of Bug 6156686
650: CURSOR C1
651: IS
652: SELECT NULL
653: FROM DUAL
654: WHERE EXISTS
655: (SELECT NULL
656: FROM pa_structures_tasks_tmp
657: WHERE proj_element_id IS NULL);

Line 662: FROM DUAL

658:
659: CURSOR C2
660: IS
661: SELECT 'Y'
662: FROM DUAL
663: WHERE EXISTS
664: (SELECT 1
665: FROM pa_object_relationships
666: WHERE relationship_type='D');

Line 671: FROM DUAL

667:
668: CURSOR C3(c_ci_type VARCHAR2)
669: IS
670: SELECT NULL
671: FROM DUAL
672: WHERE EXISTS
673: (SELECT 1
674: FROM pa_control_items pci,
675: pa_structures_tasks_tmp t1,

Line 685: FROM DUAL

681:
682: CURSOR C4(p_project_id number)
683: IS
684: SELECT 'Y'
685: FROM DUAL
686: WHERE EXISTS
687: (SELECT 1
688: FROM pa_percent_completes ppc
689: WHERE ppc.project_id=p_project_id);