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.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on DUAL

Line 23: FROM DUAL

19: and pbl.burdened_cost IS NOT null;--Condition added for Bug 5402500
20:
21: CURSOR exp_items_csr IS
22: SELECT 1
23: FROM DUAL
24: WHERE EXISTS
25: (SELECT 'X'
26: FROM gms_award_distributions adl,
27: pa_expenditure_items_all exp

Line 36: FROM DUAL

32: AND exp.expenditure_item_date < P_START_DATE) ;
33:
34: CURSOR enc_items_csr IS
35: SELECT 1
36: FROM DUAL
37: WHERE EXISTS
38: (SELECT 'X'
39: FROM gms_award_distributions adl,
40: gms_encumbrance_items_all enc

Line 62: FROM DUAL

58: -- = Allow to change before fully liquidated encumbrances.
59: -- = ============================================================
60: CURSOR enc_items_csr2 IS
61: SELECT 1
62: FROM DUAL
63: WHERE EXISTS
64: (SELECT 'X'
65: FROM gms_award_distributions adl1,
66: gms_encumbrance_items_all enc1,

Line 90: FROM DUAL

86: enc2.encumbrance_item_date < P_START_DATE ) ) ;
87:
88: CURSOR po_items_csr IS
89: SELECT 1
90: FROM DUAL
91: WHERE EXISTS
92: (SELECT 'X'
93: FROM gms_award_distributions adl,
94: po_distributions_all po

Line 105: FROM DUAL

101: AND po.expenditure_item_date < P_START_DATE );
102:
103: CURSOR ap_items_csr IS
104: SELECT 1
105: FROM DUAL
106: WHERE EXISTS
107: (SELECT 'X'
108: FROM gms_award_distributions adl,
109: ap_invoice_distributions_all ap

Line 117: FROM DUAL

113: AND ap.expenditure_item_date < P_START_DATE );
114:
115: CURSOR req_items_csr IS
116: SELECT 1
117: FROM DUAL
118: WHERE EXISTS
119: (SELECT 'X'
120: FROM gms_award_distributions adl,
121: po_req_distributions_all req

Line 239: FROM DUAL

235:
236:
237: CURSOR exp_items_csr IS
238: SELECT 1
239: FROM DUAL
240: WHERE EXISTS
241: (SELECT 'X'
242: FROM gms_award_distributions adl,
243: pa_expenditure_items_all exp

Line 252: FROM DUAL

248: AND exp.expenditure_item_date > P_END_DATE) ;
249:
250: CURSOR enc_items_csr IS
251: SELECT 1
252: FROM DUAL
253: WHERE EXISTS
254: (SELECT 'X'
255: FROM gms_award_distributions adl,
256: gms_encumbrance_items_all enc

Line 278: FROM DUAL

274: -- = Allow to change before fully liquidated encumbrances.
275: -- = ============================================================
276: CURSOR enc_items_csr2 IS
277: SELECT 1
278: FROM DUAL
279: WHERE EXISTS
280: (SELECT 'X'
281: FROM gms_award_distributions adl1,
282: gms_encumbrance_items_all enc1,

Line 306: FROM DUAL

302: enc2.encumbrance_item_date > P_END_DATE ) ) ;
303:
304: CURSOR po_items_csr IS
305: SELECT 1
306: FROM DUAL
307: WHERE EXISTS
308: (SELECT 'X'
309: FROM gms_award_distributions adl,
310: po_distributions_all po

Line 321: FROM DUAL

317: AND po.expenditure_item_date > P_END_DATE );
318:
319: CURSOR ap_items_csr IS
320: SELECT 1
321: FROM DUAL
322: WHERE EXISTS
323: (SELECT 'X'
324: FROM gms_award_distributions adl,
325: ap_invoice_distributions_all ap

Line 333: FROM DUAL

329: AND ap.expenditure_item_date > P_END_DATE );
330:
331: CURSOR req_items_csr IS
332: SELECT 1
333: FROM DUAL
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM gms_award_distributions adl,
337: po_req_distributions_all req

Line 546: FROM DUAL

542: /* Bug# 4138033, apart from adding the task id condition, removed the joing with pa_task
543: as the project_id is available on expenditure items itself */
544: CURSOR exp_items_csr IS
545: SELECT 1
546: FROM DUAL
547: WHERE EXISTS
548: (SELECT 'X'
549: FROM pa_expenditure_items_all exp
550: /* pa_tasks tsk 4138033 */

Line 558: FROM DUAL

554: AND exp.expenditure_item_date < P_START_DATE) ;
555:
556: CURSOR enc_items_csr IS
557: SELECT 1
558: FROM DUAL
559: WHERE EXISTS
560: (SELECT 'X'
561: FROM gms_encumbrance_items_all enc,
562: pa_tasks tsk

Line 582: FROM DUAL

578: -- = Allow to change before fully liquidated encumbrances.
579: -- = ============================================================
580: CURSOR enc_items_csr2 IS
581: SELECT 1
582: FROM DUAL
583: WHERE EXISTS
584: (SELECT 'X'
585: FROM gms_encumbrance_items_all enc1,
586: gms_encumbrance_items_all enc2,

Line 600: FROM DUAL

596: enc2.encumbrance_item_date < P_START_DATE ) ) ;
597:
598: CURSOR po_items_csr IS
599: SELECT 1
600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'X'
603: FROM po_distributions_all po
604: WHERE po.project_id = P_PROJECT_ID

Line 612: FROM DUAL

608: --Bug 3985177 : Removed pa_tasks join in po_items_csr
609:
610: CURSOR ap_items_csr IS
611: SELECT 1
612: FROM DUAL
613: WHERE EXISTS
614: (SELECT 'X'
615: FROM ap_invoice_distributions_all ap
616: WHERE ap.project_id = P_PROJECT_ID

Line 624: FROM DUAL

620: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
621:
622: CURSOR req_items_csr IS
623: SELECT 1
624: FROM DUAL
625: WHERE EXISTS
626: (SELECT 'X'
627: FROM po_req_distributions_all req
628: WHERE req.project_id = P_PROJECT_ID

Line 636: FROM DUAL

632: --Bug 3985177 : Removed pa_tasks join in req_items_csr
633:
634: CURSOR budget_lines_exist_csr IS
635: SELECT 1
636: FROM DUAL
637: WHERE EXISTS
638: ( SELECT 1
639: FROM gms_budget_versions pbv,
640: gms_resource_assignments pra,

Line 650: FROM DUAL

646:
647:
648: CURSOR txn_exists_csr IS
649: SELECT 1
650: FROM DUAL
651: WHERE EXISTS
652: (SELECT 1
653: FROM gms_award_distributions adl
654: WHERE adl.project_id = P_PROJECT_ID

Line 800: FROM DUAL

796: AND pbl.burdened_cost IS NOT null; /*Code change for bug 5470902 */
797:
798: CURSOR exp_items_csr IS
799: SELECT 1
800: FROM DUAL
801: WHERE EXISTS
802: (SELECT 'X'
803: FROM pa_expenditure_items_all exp
804: /* pa_tasks tsk */

Line 812: FROM DUAL

808: AND exp.expenditure_item_date > P_COMPLETION_DATE) ;
809:
810: CURSOR enc_items_csr IS
811: SELECT 1
812: FROM DUAL
813: WHERE EXISTS
814: (SELECT 'X'
815: FROM gms_encumbrance_items_all enc,
816: pa_tasks tsk

Line 835: FROM DUAL

831: -- = Allow to change before fully liquidated encumbrances.
832: -- = ============================================================
833: CURSOR enc_items_csr2 IS
834: SELECT 1
835: FROM DUAL
836: WHERE EXISTS
837: (SELECT 'X'
838: FROM gms_encumbrance_items_all enc1,
839: gms_encumbrance_items_all enc2,

Line 853: FROM DUAL

849: enc2.encumbrance_item_date > P_COMPLETION_DATE ) ) ;
850:
851: CURSOR po_items_csr IS
852: SELECT 1
853: FROM DUAL
854: WHERE EXISTS
855: (SELECT 'X'
856: FROM po_distributions_all po
857: WHERE po.project_id = P_PROJECT_ID

Line 865: FROM DUAL

861: --Bug 3985177 : Removed pa_tasks join in po_items_csr
862:
863: CURSOR ap_items_csr IS
864: SELECT 1
865: FROM DUAL
866: WHERE EXISTS
867: (SELECT 'X'
868: FROM ap_invoice_distributions_all ap
869: WHERE ap.project_id = P_PROJECT_ID

Line 877: FROM DUAL

873: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
874:
875: CURSOR req_items_csr IS
876: SELECT 1
877: FROM DUAL
878: WHERE EXISTS
879: (SELECT 'X'
880: FROM po_req_distributions_all req
881: WHERE req.project_id = P_PROJECT_ID