APPS.PA_TASK_PUB1 dependencies on DUAL

Line 2122: FROM DUAL

2118: -- the link manually and then delete the task.
2119:
2120: CURSOR is_linked_task(c_task_version_id NUMBER) IS
2121: SELECT 'Y'
2122: FROM DUAL
2123: WHERE EXISTS(
2124: SELECT pors.object_relationship_id
2125: FROM pa_object_relationships pors,
2126: pa_object_relationships pors1

Line 9106: FROM dual

9102: AND pst.structure_type_class_code IN( 'FINANCIAL' );
9103:
9104: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
9105: SELECT 'Y'
9106: FROM dual
9107: WHERE EXISTS(
9108: SELECT 'xyz'
9109: FROM pa_proj_elem_ver_structure
9110: WHERE proj_element_id = c_structure_id

Line 9144: FROM dual

9140: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
9141:
9142: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
9143: SELECT '1'
9144: FROM dual
9145: WHERE EXISTS
9146: (SELECT 'xyz'
9147: FROM pa_object_relationships
9148: WHERE object_id_from1 = c_task_version_id

Line 10574: FROM dual

10570: AND pst.structure_type_class_code IN( 'FINANCIAL' );
10571:
10572: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
10573: SELECT 'Y'
10574: FROM dual
10575: WHERE EXISTS(
10576: SELECT 'xyz'
10577: FROM pa_proj_elem_ver_structure
10578: WHERE proj_element_id = c_structure_id

Line 10612: FROM dual

10608: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
10609:
10610: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
10611: SELECT '1'
10612: FROM dual
10613: WHERE EXISTS
10614: (SELECT 'xyz'
10615: FROM pa_object_relationships
10616: WHERE object_id_from1 = c_task_version_id

Line 15757: FROM DUAL

15753: CONNECT BY object_id_from1 = PRIOR object_id_to1
15754: and relationship_type = 'S'
15755: UNION
15756: SELECT to_number(null) object_id_from1, c_task_version_id object_id_to1
15757: FROM DUAL
15758: ) pobj
15759: WHERE
15760: ppv2.element_version_id = por1.object_id_to1
15761: AND por1.object_id_from1 = por2.object_id_to1