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 184: FROM DUAL;

180: AND object_type_to = PRIOR object_type_from
181: AND relationship_type = PRIOR relationship_type
182: UNION
183: SELECT p_task_version_id_WP
184: FROM DUAL;
185:
186: --This Cursor will return 'X' if any mapping already exists for the passed workplan task id
187: CURSOR c_dup_mapping_exists (l_from_task_id NUMBER)
188: IS

Line 190: FROM dual

186: --This Cursor will return 'X' if any mapping already exists for the passed workplan task id
187: CURSOR c_dup_mapping_exists (l_from_task_id NUMBER)
188: IS
189: SELECT 'X'
190: FROM dual
191: WHERE EXISTS
192: (
193: SELECT NULL
194: FROM PA_OBJECT_RELATIONSHIPS