APPS.PA_TASK_UTILS dependencies on DUAL

Line 178: from sys.dual

174: x_project_id number;
175:
176: cursor c1 is
177: select 1
178: from sys.dual
179: where exists (SELECT null
180: FROM PA_TASKS
181: WHERE PROJECT_ID = x_project_id
182: and task_id <> x_task_id

Line 230: from sys.dual

226: x_parent_task_id number;
227:
228: cursor c1 is
229: select 1
230: from sys.dual
231: where exists (SELECT null
232: FROM PA_TASKS
233: WHERE TASK_ID <> x_TASK_ID
234: AND PARENT_TASK_ID = x_PARENT_TASK_ID);

Line 278: from sys.dual

274: is
275:
276: cursor c1 is
277: select 1
278: from sys.dual
279: where exists (SELECT null
280: FROM pa_percent_completes
281: where TASK_ID IN
282: (SELECT TASK_ID

Line 1103: SYS.DUAL

1099:
1100: CURSOR Cdl_Cur IS
1101: SELECT NULL
1102: FROM
1103: SYS.DUAL
1104: WHERE EXISTS
1105: (SELECT NULL
1106: FROM
1107: pa_expenditure_items_all paei,

Line 1116: SYS.DUAL

1112:
1113: CURSOR Rdl_Cur IS
1114: SELECT NULL
1115: FROM
1116: SYS.DUAL
1117: WHERE EXISTS
1118: (SELECT NULL
1119: FROM
1120: pa_expenditure_items_all paei,

Line 1129: SYS.DUAL

1125:
1126: CURSOR Draft_Inv_Cur IS
1127: SELECT NULL
1128: FROM
1129: SYS.DUAL
1130: WHERE EXISTS
1131: (SELECT NULL
1132: FROM
1133: pa_draft_invoice_items dii

Line 1707: FROM sys.dual

1703: x_err_stage := 'check pa_fp_elements for task '|| x_task_id;
1704: declare
1705: cursor c1 is
1706: SELECT 1
1707: FROM sys.dual
1708: where exists (SELECT NULL
1709: FROM pa_fp_elements r
1710: where r.TASK_ID IN
1711: (SELECT TASK_ID

Line 1740: FROM sys.dual

1736: x_err_stage := 'check budget for task '|| x_task_id;
1737: declare
1738: cursor c1 is
1739: SELECT 1
1740: FROM sys.dual
1741: where exists (SELECT NULL
1742: FROM pa_resource_assignments r
1743: where r.TASK_ID IN
1744: (SELECT TASK_ID

Line 2216: from sys.dual

2212: is
2213:
2214: cursor c1 is
2215: select 1
2216: from sys.dual
2217: where exists (SELECT null
2218: FROM pa_tasks
2219: where parent_task_id = x_task_id);
2220: