APPS.PA_PROJ_STRUC_MAPPING_UTILS dependencies on DUAL

Line 51: FROM DUAL

47:
48: CURSOR c_mapping_exists (l_elem_version_id NUMBER)
49: IS
50: SELECT 'X'
51: FROM DUAL
52: WHERE EXISTS
53: ( SELECT NULL
54: FROM PA_OBJECT_RELATIONSHIPS
55: WHERE OBJECT_ID_TO1 = l_elem_version_id

Line 175: FROM DUAL;

171: START WITH object_id_to1 = p_task_version_id_WP
172: CONNECT BY Object_id_to1 = PRIOR object_id_from1
173: UNION
174: SELECT p_task_version_id_WP
175: FROM DUAL;
176:
177: --This Cursor will return 'X' if any mapping already exists for the passed workplan task id
178: CURSOR c_dup_mapping_exists (l_from_task_id NUMBER)
179: IS

Line 181: FROM dual

177: --This Cursor will return 'X' if any mapping already exists for the passed workplan task id
178: CURSOR c_dup_mapping_exists (l_from_task_id NUMBER)
179: IS
180: SELECT 'X'
181: FROM dual
182: WHERE EXISTS
183: (
184: SELECT NULL
185: FROM PA_OBJECT_RELATIONSHIPS