eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_TSK_UTILS dependencies on DUAL

Line 64: from sys.dual

60: x_proj_id number;
61:
62: cursor c1 is
63: select 1
64: from sys.dual
65: where exists (select event_num
66: from pa_events
67: where project_id = x_proj_id
68: and (x_task_id is null or

Line 136: FROM sys.dual

132: return number
133: is
134: cursor c1 is
135: SELECT 1
136: FROM sys.dual
137: WHERE EXISTS (SELECT NULL
138: FROM pa_expenditure_items_all i
139: WHERE i.project_id = x_project_id)
140: OR EXISTS

Line 147: FROM sys.dual

143: WHERE e.project_id = x_project_id);
144:
145: cursor c2 is
146: SELECT 1
147: FROM sys.dual
148: where exists (SELECT NULL
149: FROM PA_EXPENDITURE_ITEMS_all
150: WHERE TASK_ID IN
151: (SELECT TASK_ID

Line 164: FROM sys.dual

160: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
161: START WITH TASK_ID = x_TASK_ID));
162: cursor c3 is
163: SELECT 1
164: FROM sys.dual
165: where exists (SELECT NULL
166: FROM PA_EXPENDITURE_ITEMS_all
167: WHERE TASK_ID = x_TASK_ID)
168: or exists (SELECT NULL

Line 174: FROM sys.dual

170: WHERE TASK_ID = x_TASK_ID);
171:
172: /* cursor c2 is
173: SELECT 1
174: FROM sys.dual
175: where exists (SELECT NULL
176: FROM PA_EXPENDITURE_ITEMS_all
177: WHERE TASK_ID IN
178: (SELECT TASK_ID

Line 184: FROM sys.dual

180: WHERE TASK_ID = x_TASK_ID));
181:
182: cursor c3 is
183: SELECT 1
184: FROM sys.dual
185: where exists (SELECT NULL
186: FROM PA_EXPENDITURE_ITEMS_all
187: WHERE TASK_ID IN
188: (SELECT TASK_ID

Line 268: FROM sys.dual

264: x_proj_id number;
265:
266: cursor c1 is
267: SELECT 1
268: FROM sys.dual
269: WHERE EXISTS (SELECT NULL
270: FROM po_distributions_all
271: WHERE project_id = x_project_id
272: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag

Line 276: FROM sys.dual

272: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag
273:
274: cursor c2 is
275: SELECT 1
276: FROM sys.dual
277: where exists (SELECT NULL
278: FROM po_distributions_all
279: where project_id = x_proj_id
280: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag

Line 289: FROM sys.dual

285: START WITH TASK_ID = x_TASK_ID));
286:
287: /* cursor c2 is
288: SELECT 1
289: FROM sys.dual
290: where exists (SELECT NULL
291: FROM po_distributions_all
292: where project_id = x_proj_id
293: AND TASK_ID IN

Line 304: FROM sys.dual

300:
301: -- New cursor c3 added for Performance Fix 4903460
302: cursor c3 is
303: SELECT 1
304: FROM sys.dual
305: where exists (SELECT NULL
306: FROM po_distributions_all
307: where project_id = x_proj_id
308: AND TASK_ID = x_TASK_ID);

Line 392: FROM sys.dual

388: x_proj_id number;
389:
390: cursor c1 is
391: SELECT 1
392: FROM sys.dual
393: WHERE EXISTS (SELECT NULL
394: FROM po_req_distributions_all
395: WHERE project_id = x_project_id
396: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag

Line 400: FROM sys.dual

396: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag
397:
398: cursor c2 is
399: SELECT 1
400: FROM sys.dual
401: where exists (SELECT NULL
402: FROM po_req_distributions_all
403: where project_id = x_proj_id
404: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag

Line 413: FROM sys.dual

409: START WITH TASK_ID = x_TASK_ID));
410:
411: /* cursor c2 is
412: SELECT 1
413: FROM sys.dual
414: where exists (SELECT NULL
415: FROM po_req_distributions_all
416: where project_id = x_proj_id
417: AND TASK_ID IN

Line 428: FROM sys.dual

424:
425: -- New cursor c3 added for Performance Fix 4903460
426: cursor c3 is
427: SELECT 1
428: FROM sys.dual
429: where exists (SELECT NULL
430: FROM po_req_distributions_all
431: where project_id = x_proj_id
432: AND TASK_ID = x_TASK_ID);

Line 515: FROM sys.dual

511: x_proj_id number;
512:
513: cursor c1 is
514: SELECT 1
515: FROM sys.dual
516: WHERE EXISTS (SELECT NULL
517: FROM ap_invoices_all
518: WHERE project_id = x_project_id);
519:

Line 522: FROM sys.dual

518: WHERE project_id = x_project_id);
519:
520: cursor c2 is
521: SELECT 1
522: FROM sys.dual
523: where exists (SELECT NULL
524: FROM ap_invoices_all
525: where project_id = x_proj_id
526: AND TASK_ID IN

Line 534: FROM sys.dual

530: START WITH TASK_ID = x_TASK_ID));
531:
532: /* cursor c2 is
533: SELECT 1
534: FROM sys.dual
535: where exists (SELECT NULL
536: FROM ap_invoices_all
537: where project_id = x_proj_id
538: AND TASK_ID IN

Line 549: FROM sys.dual

545:
546: -- New cursor c3 added for Performance Fix 4903460
547: cursor c3 is
548: SELECT 1
549: FROM sys.dual
550: where exists (SELECT NULL
551: FROM ap_invoices_all
552: where project_id = x_proj_id
553: AND TASK_ID = x_task_id);

Line 638: FROM sys.dual

634: x_proj_id number;
635:
636: cursor c1 is
637: SELECT 1
638: FROM sys.dual
639: WHERE EXISTS (SELECT NULL
640: FROM ap_invoice_distributions_all
641: WHERE project_id = x_project_id
642: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag

Line 646: FROM sys.dual

642: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag
643:
644: cursor c2 is
645: SELECT 1
646: FROM sys.dual
647: where exists (SELECT NULL
648: FROM ap_invoice_distributions_all
649: where project_id = x_proj_id
650: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag

Line 659: FROM sys.dual

655: START WITH TASK_ID = x_TASK_ID));
656:
657: /* cursor c2 is
658: SELECT 1
659: FROM sys.dual
660: where exists (SELECT NULL
661: FROM ap_invoice_distributions_all
662: where project_id = x_proj_id
663: AND TASK_ID IN

Line 674: FROM sys.dual

670:
671: -- New cursor c3 added for Performance Fix 4903460
672: cursor c3 is
673: SELECT 1
674: FROM sys.dual
675: where exists (SELECT NULL
676: FROM ap_invoice_distributions_all
677: where project_id = x_proj_id
678: AND TASK_ID = x_TASK_ID);

Line 755: FROM sys.dual

751: x_proj_id number;
752:
753: cursor c1 is
754: SELECT 1
755: FROM sys.dual
756: WHERE EXISTS (SELECT NULL
757: FROM pa_project_fundings
758: WHERE project_id = x_project_id);
759:

Line 762: FROM sys.dual

758: WHERE project_id = x_project_id);
759:
760: cursor c2 is
761: SELECT 1
762: FROM sys.dual
763: where exists (SELECT NULL
764: FROM pa_project_fundings
765: where project_id = x_proj_id
766: AND TASK_ID = x_task_id);

Line 833: from sys.dual

829: , x_task_id IN number ) return number
830: is
831: cursor c1 is
832: select 1
833: from sys.dual
834: where exists (SELECT NULL
835: FROM PA_EXPENDITURE_ITEMS_all PAI,
836: PA_COST_DISTRIBUTION_LINES_all PCD
837: WHERE PAI.PROJECT_ID = x_PROJECT_ID

Line 843: from sys.dual

839:
840:
841: cursor c2 is
842: select 1
843: from sys.dual
844: where exists (SELECT NULL
845: FROM PA_EXPENDITURE_ITEMS_all PAI,
846: PA_COST_DISTRIBUTION_LINES_all PCD
847: WHERE PAI.EXPENDITURE_ITEM_ID

Line 908: from sys.dual

904: is
905:
906: cursor c1 is
907: select 1
908: from sys.dual
909: where exists (SELECT NULL
910: FROM pa_cust_rev_dist_lines rdl
911: where rdl.project_id = x_project_id);
912:

Line 915: from sys.dual

911: where rdl.project_id = x_project_id);
912:
913: cursor c2 is
914: select 1
915: from sys.dual
916: where exists (SELECT NULL
917: from pa_cust_rev_dist_lines rdl
918: , pa_expenditure_items i
919: where i.expenditure_item_id = rdl.expenditure_item_id

Line 984: from sys.dual

980: x_proj_id number;
981:
982: cursor c1 is
983: select 1
984: from sys.dual
985: where exists (SELECT NULL
986: FROM pa_cust_event_rev_dist_lines
987: where PROJECT_ID = x_PROJECT_ID
988: AND nvl(x_event_num, event_num) = event_num );

Line 992: from sys.dual

988: AND nvl(x_event_num, event_num) = event_num );
989:
990: cursor c2 is
991: select 1
992: from sys.dual
993: where exists (SELECT NULL
994: FROM pa_cust_event_rev_dist_lines
995: where project_id = x_proj_id
996: AND TASK_ID = x_TASK_ID

Line 1072: FROM sys.dual

1068: x_proj_id number;
1069:
1070: cursor c1 is
1071: SELECT 1
1072: FROM sys.dual
1073: WHERE EXISTS (SELECT NULL
1074: FROM pa_draft_invoice_items
1075: WHERE project_id = x_project_id);
1076:

Line 1079: FROM sys.dual

1075: WHERE project_id = x_project_id);
1076:
1077: cursor c2 is
1078: SELECT 1
1079: FROM sys.dual
1080: where exists (SELECT NULL
1081: FROM pa_draft_invoice_items
1082: where project_id = x_proj_id
1083: AND TASK_ID IN

Line 1091: FROM sys.dual

1087: START WITH TASK_ID = x_TASK_ID));
1088:
1089: /* cursor c2 is
1090: SELECT 1
1091: FROM sys.dual
1092: where exists (SELECT NULL
1093: FROM pa_draft_invoice_items
1094: where project_id = x_proj_id
1095: AND TASK_ID IN

Line 1106: FROM sys.dual

1102:
1103: -- New cursor c3 added for Performance Fix 4903460
1104: cursor c3 is
1105: SELECT 1
1106: FROM sys.dual
1107: where exists (SELECT NULL
1108: FROM pa_draft_invoice_items
1109: where project_id = x_proj_id
1110: AND TASK_ID = x_TASK_ID);

Line 1183: FROM sys.dual

1179: )return number
1180: is
1181: cursor c1 is
1182: SELECT 1
1183: FROM sys.dual
1184: where exists (SELECT NULL
1185: FROM pa_draft_invoice_details_all
1186: where CC_TAX_TASK_ID IN
1187: (SELECT TASK_ID

Line 1196: FROM sys.dual

1192: c1_rec c1%rowtype;
1193: -- New cursor c2 added for Performance Fix 4903460
1194: cursor c2 is
1195: SELECT 1
1196: FROM sys.dual
1197: where exists (SELECT NULL
1198: FROM pa_draft_invoice_details_all
1199: where CC_TAX_TASK_ID = x_TASK_ID);
1200: c2_rec c2%rowtype;

Line 1254: FROM sys.dual

1250: ) return number
1251: is
1252: cursor c1 is
1253: SELECT 1
1254: FROM sys.dual
1255: where exists (SELECT NULL
1256: FROM pa_project_customers
1257: where receiver_task_id IN
1258: (SELECT TASK_ID

Line 1267: FROM sys.dual

1263: c1_rec c1%rowtype;
1264: -- New cursor c2 added for Performance Fix 4903460
1265: cursor c2 is
1266: SELECT 1
1267: FROM sys.dual
1268: where exists (SELECT NULL
1269: FROM pa_project_customers
1270: where receiver_task_id = X_TASK_ID);
1271: c2_rec c2%rowtype;

Line 1327: FROM sys.dual

1323: )return number
1324: is
1325: cursor c1 is
1326: SELECT 1
1327: FROM sys.dual
1328: where exists (SELECT NULL
1329: FROM pa_projects_all -- Modified pa_projects to pa_projects_all for bug#3512486
1330: where project_id = (select project_id from pa_tasks where task_id=X_TASK_ID)
1331: and CC_TAX_TASK_ID IN

Line 1342: FROM sys.dual

1338: -- New cursor c2 added for Performance Fix 4903460
1339: x_proj_id NUMBER;
1340: cursor c2 is
1341: SELECT 1
1342: FROM sys.dual
1343: where exists (SELECT NULL
1344: FROM pa_projects_all
1345: where project_id = x_proj_id
1346: and CC_TAX_TASK_ID = x_task_id);

Line 1412: FROM sys.dual

1408: x_proj_id number;
1409:
1410: cursor c1 is
1411: SELECT 1
1412: FROM sys.dual
1413: WHERE EXISTS (SELECT NULL
1414: FROM pa_draft_revenue_items
1415: WHERE project_id = x_project_id);
1416:

Line 1419: FROM sys.dual

1415: WHERE project_id = x_project_id);
1416:
1417: cursor c2 is
1418: SELECT 1
1419: FROM sys.dual
1420: where exists (SELECT NULL
1421: FROM pa_draft_revenue_items
1422: where project_id = x_proj_id
1423: AND TASK_ID IN

Line 1431: FROM sys.dual

1427: START WITH TASK_ID = x_TASK_ID));
1428:
1429: /* cursor c2 is
1430: SELECT 1
1431: FROM sys.dual
1432: where exists (SELECT NULL
1433: FROM pa_draft_revenue_items
1434: where project_id = x_proj_id
1435: AND TASK_ID IN

Line 1446: FROM sys.dual

1442: c2_rec c2%rowtype;
1443: -- New cursor c3 added for Performance Fix 4903460
1444: cursor c3 is
1445: SELECT 1
1446: FROM sys.dual
1447: where exists (SELECT NULL
1448: FROM pa_draft_revenue_items
1449: where project_id = x_proj_id
1450: AND TASK_ID =x_task_id);

Line 1534: FROM sys.dual

1530: x_proj_id number;
1531:
1532: cursor c1 is
1533: SELECT 1
1534: FROM sys.dual
1535: WHERE EXISTS (SELECT NULL
1536: FROM pa_commitment_txns
1537: WHERE project_id = x_project_id);
1538:

Line 1541: FROM sys.dual

1537: WHERE project_id = x_project_id);
1538:
1539: cursor c2 is
1540: SELECT 1
1541: FROM sys.dual
1542: where exists (SELECT NULL
1543: FROM pa_commitment_txns
1544: where project_id = x_proj_id
1545: AND TASK_ID IN

Line 1554: FROM sys.dual

1550:
1551:
1552: /* cursor c2 is
1553: SELECT 1
1554: FROM sys.dual
1555: where exists (SELECT NULL
1556: FROM pa_commitment_txns
1557: where project_id = x_proj_id
1558: AND TASK_ID IN

Line 1569: FROM sys.dual

1565:
1566: -- New cursor c3 added for Performance Fix 4903460
1567: cursor c3 is
1568: SELECT 1
1569: FROM sys.dual
1570: where exists (SELECT NULL
1571: FROM pa_commitment_txns
1572: where project_id = x_proj_id
1573: AND TASK_ID = x_TASK_ID);

Line 1656: FROM sys.dual

1652: x_proj_id number;
1653:
1654: cursor c1 is
1655: SELECT 1
1656: FROM sys.dual
1657: WHERE EXISTS (SELECT NULL
1658: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1659: WHERE project_id = x_project_id)
1660: UNION

Line 1662: FROM sys.dual

1658: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1659: WHERE project_id = x_project_id)
1660: UNION
1661: SELECT 1
1662: FROM sys.dual
1663: WHERE EXISTS (SELECT NULL
1664: FROM pa_org_labor_sch_rule
1665: WHERE overtime_project_id = x_project_id);
1666:

Line 1669: FROM sys.dual

1665: WHERE overtime_project_id = x_project_id);
1666:
1667: cursor c2 is
1668: SELECT 1
1669: FROM sys.dual
1670: where exists (SELECT NULL
1671: FROM pa_comp_rule_ot_defaults_all -- Bug 4680097: pa_compensation_rule_sets
1672: where project_id = x_proj_id
1673: AND TASK_ID IN

Line 1680: FROM sys.dual

1676: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
1677: START WITH TASK_ID = x_TASK_ID))
1678: UNION
1679: SELECT 1
1680: FROM sys.dual
1681: where exists (SELECT NULL
1682: FROM pa_org_labor_sch_rule
1683: where overtime_project_id = x_proj_id
1684: AND overtime_TASK_ID IN

Line 1692: FROM sys.dual

1688: START WITH TASK_ID = x_TASK_ID));
1689:
1690: /* cursor c2 is
1691: SELECT 1
1692: FROM sys.dual
1693: where exists (SELECT NULL
1694: FROM pa_compensation_rule_sets
1695: where project_id = x_proj_id
1696: AND TASK_ID IN

Line 1707: FROM sys.dual

1703:
1704: -- New cursor c3 added for Performance Fix 4903460
1705: cursor c3 is
1706: SELECT 1
1707: FROM sys.dual
1708: WHERE
1709: exists (SELECT NULL
1710: FROM pa_comp_rule_ot_defaults_all
1711: where project_id = x_proj_id

Line 1804: FROM sys.dual

1800: x_proj_id number;
1801:
1802: cursor c1 is
1803: SELECT 1
1804: FROM sys.dual
1805: WHERE EXISTS (SELECT NULL
1806: FROM pa_project_asset_assignments
1807: WHERE project_id = x_project_id);
1808:

Line 1822: FROM sys.dual

1818: /*Commented for bug6063643
1819:
1820: cursor c2 is
1821: SELECT 1
1822: FROM sys.dual
1823: where exists (SELECT NULL
1824: FROM pa_project_asset_assignments
1825: where project_id = x_proj_id
1826: AND TASK_ID IN

Line 1836: FROM sys.dual

1832: commented for bug6063643*/
1833:
1834: /* cursor c2 is
1835: SELECT 1
1836: FROM sys.dual
1837: where exists (SELECT NULL
1838: FROM pa_project_asset_assignments
1839: where project_id = x_proj_id
1840: AND TASK_ID IN

Line 1851: FROM sys.dual

1847:
1848: -- New cursor c3 added for Performance Fix 4903460
1849: cursor c3 is
1850: SELECT 1
1851: FROM sys.dual
1852: where exists (SELECT NULL
1853: FROM pa_project_asset_assignments
1854: where project_id = x_proj_id
1855: AND TASK_ID = x_task_id);

Line 1929: FROM sys.dual

1925: , x_task_id IN number ) return number
1926: is
1927: cursor c1 is
1928: SELECT 1
1929: FROM sys.dual
1930: where exists (SELECT NULL
1931: FROM PA_JOB_BILL_RATE_OVERRIDES
1932: WHERE project_id = x_project_id
1933: and task_id is null);

Line 1937: FROM sys.dual

1933: and task_id is null);
1934:
1935: cursor c2 is
1936: SELECT 1
1937: FROM sys.dual
1938: where exists (SELECT NULL
1939: FROM PA_JOB_BILL_RATE_OVERRIDES
1940: WHERE TASK_ID = x_task_ID);
1941:

Line 1998: FROM sys.dual

1994: , x_task_id IN number ) return number
1995: is
1996: cursor c1 is
1997: SELECT 1
1998: FROM sys.dual
1999: where exists (SELECT NULL
2000: FROM pa_ind_rate_schedules
2001: WHERE project_id = x_project_id);
2002:

Line 2005: FROM sys.dual

2001: WHERE project_id = x_project_id);
2002:
2003: cursor c2 is
2004: SELECT 1
2005: FROM sys.dual
2006: where exists (SELECT NULL
2007: FROM pa_ind_rate_schedules
2008: WHERE TASK_ID = x_task_ID);
2009:

Line 2068: FROM sys.dual

2064: , x_task_id IN number ) return number
2065: is
2066: cursor c1 is
2067: SELECT 1
2068: FROM sys.dual
2069: where exists (SELECT NULL
2070: FROM PA_EMP_BILL_RATE_OVERRIDES
2071: WHERE project_id = x_project_id);
2072:

Line 2076: FROM sys.dual

2072:
2073: /* bug 2550288 changed below cursor to refer PA_EMP_BILL_RATE_OVERRIDES instead of PA_JOB_BILL_RATE_OVERRIDES */
2074: cursor c2 is
2075: SELECT 1
2076: FROM sys.dual
2077: where exists (SELECT NULL
2078: FROM PA_EMP_BILL_RATE_OVERRIDES
2079: WHERE TASK_ID = x_task_ID);
2080:

Line 2137: FROM sys.dual

2133: , x_task_id IN number ) return number
2134: is
2135: cursor c1 is
2136: SELECT 1
2137: FROM sys.dual
2138: where exists (SELECT NULL
2139: FROM PA_LABOR_MULTIPLIERS
2140: WHERE project_id = x_project_id);
2141:

Line 2144: FROM sys.dual

2140: WHERE project_id = x_project_id);
2141:
2142: cursor c2 is
2143: SELECT 1
2144: FROM sys.dual
2145: where exists (SELECT NULL
2146: FROM PA_LABOR_MULTIPLIERS
2147: WHERE TASK_ID = x_task_id);
2148:

Line 2208: FROM sys.dual

2204: is
2205: task_project_id number;
2206: cursor c1 is
2207: SELECT 1
2208: FROM sys.dual
2209: where exists (SELECT NULL
2210: FROM PA_TRANSACTION_CONTROLS
2211: WHERE project_id = x_project_id);
2212:

Line 2215: FROM sys.dual

2211: WHERE project_id = x_project_id);
2212:
2213: cursor c2 is
2214: SELECT 1
2215: FROM sys.dual
2216: where exists (SELECT NULL
2217: FROM PA_TRANSACTION_CONTROLS
2218: WHERE TASK_ID = x_task_ID
2219: AND PROJECT_ID = task_project_id);

Line 2285: FROM sys.dual

2281: , x_task_id IN number ) return number
2282: is
2283: cursor c1 is
2284: SELECT 1
2285: FROM sys.dual
2286: where exists (SELECT NULL
2287: FROM PA_NL_BILL_RATE_OVERRIDES
2288: WHERE project_id = x_project_id);
2289:

Line 2292: FROM sys.dual

2288: WHERE project_id = x_project_id);
2289:
2290: cursor c2 is
2291: SELECT 1
2292: FROM sys.dual
2293: where exists (SELECT NULL
2294: FROM PA_NL_BILL_RATE_OVERRIDES
2295: WHERE TASK_ID = x_task_ID);
2296:

Line 2352: FROM sys.dual

2348: , x_task_id IN number ) return number
2349: is
2350: cursor c1 is
2351: SELECT 1
2352: FROM sys.dual
2353: where exists (SELECT NULL
2354: FROM PA_JOB_BILL_TITLE_OVERRIDES
2355: WHERE project_id = x_project_id);
2356:

Line 2359: FROM sys.dual

2355: WHERE project_id = x_project_id);
2356:
2357: cursor c2 is
2358: SELECT 1
2359: FROM sys.dual
2360: where exists (SELECT NULL
2361: FROM PA_JOB_BILL_TITLE_OVERRIDES
2362: WHERE TASK_ID = x_task_ID);
2363:

Line 2421: FROM sys.dual

2417: , x_task_id IN number ) return number
2418: is
2419: cursor c1 is
2420: SELECT 1
2421: FROM sys.dual
2422: where exists (SELECT NULL
2423: FROM PA_JOB_ASSIGNMENT_OVERRIDES
2424: WHERE project_id = x_project_id);
2425:

Line 2428: FROM sys.dual

2424: WHERE project_id = x_project_id);
2425:
2426: cursor c2 is
2427: SELECT 1
2428: FROM sys.dual
2429: where exists (SELECT NULL
2430: FROM PA_JOB_ASSIGNMENT_OVERRIDES
2431: WHERE TASK_ID = x_task_id);
2432:

Line 2477: from dual

2473: begin
2474: -- anlee
2475: /* Commented out for bug 2790785
2476: select 1 into x_exist
2477: from dual
2478: where EXISTS (select * from ap_expense_report_lines_all a, ap_expense_report_headers_all b
2479: where a.task_id = x_task_id
2480: and a.REPORT_HEADER_ID = b.REPORT_HEADER_ID
2481: and b.source <> 'Oracle Project Accounting');

Line 2486: FROM DUAL

2482: */
2483: /* Commented for bug 4060239
2484: -- Fix from bug 2790785
2485: SELECT 1 into x_exist
2486: FROM DUAL
2487: WHERE EXISTS (SELECT * FROM AP_EXPENSE_REPORT_LINES_ALL A, AP_EXPENSE_REPORT_HEADERS_ALL B
2488: WHERE A.TASK_ID = x_task_id
2489: AND A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
2490: AND B.SOURCE <> 'Oracle Project Accounting'

Line 2569: FROM sys.dual

2565: x_proj_id number;
2566:
2567: cursor c1 is
2568: SELECT 1
2569: FROM sys.dual
2570: WHERE EXISTS (SELECT NULL
2571: FROM cs_estimate_details
2572: WHERE project_id = x_project_id
2573: UNION

Line 2585: FROM sys.dual

2581: );
2582:
2583: cursor c2 is
2584: SELECT 1
2585: FROM sys.dual
2586: where exists (SELECT NULL
2587: FROM cs_estimate_details
2588: where project_id = x_proj_id
2589: AND project_TASK_ID IN

Line 2620: FROM sys.dual

2616: c2_rec c2%rowtype;
2617:
2618: cursor c3 is
2619: SELECT 1
2620: FROM sys.dual
2621: where exists (SELECT NULL
2622: FROM cs_estimate_details
2623: where project_id = x_proj_id
2624: AND project_TASK_ID = x_TASK_ID