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 108: FROM DUAL

104: AND nvl(cancel_flag,'N') <> 'Y' );
105:
106: CURSOR ap_items_csr IS
107: SELECT 1
108: FROM DUAL
109: WHERE EXISTS
110: (SELECT 'X'
111: FROM gms_award_distributions adl,
112: ap_invoice_distributions_all ap ,

Line 123: FROM DUAL

119: AND ai.cancelled_date is null);
120:
121: CURSOR req_items_csr IS
122: SELECT 1
123: FROM DUAL
124: WHERE EXISTS
125: (SELECT 'X'
126: FROM gms_award_distributions adl,
127: po_req_distributions_all req ,

Line 248: FROM DUAL

244:
245:
246: CURSOR exp_items_csr IS
247: SELECT 1
248: FROM DUAL
249: WHERE EXISTS
250: (SELECT 'X'
251: FROM gms_award_distributions adl,
252: pa_expenditure_items_all exp

Line 261: FROM DUAL

257: AND exp.expenditure_item_date > P_END_DATE) ;
258:
259: CURSOR enc_items_csr IS
260: SELECT 1
261: FROM DUAL
262: WHERE EXISTS
263: (SELECT 'X'
264: FROM gms_award_distributions adl,
265: gms_encumbrance_items_all enc

Line 287: FROM DUAL

283: -- = Allow to change before fully liquidated encumbrances.
284: -- = ============================================================
285: CURSOR enc_items_csr2 IS
286: SELECT 1
287: FROM DUAL
288: WHERE EXISTS
289: (SELECT 'X'
290: FROM gms_award_distributions adl1,
291: gms_encumbrance_items_all enc1,

Line 315: FROM DUAL

311: enc2.encumbrance_item_date > P_END_DATE ) ) ;
312:
313: CURSOR po_items_csr IS
314: SELECT 1
315: FROM DUAL
316: WHERE EXISTS
317: (SELECT 'X'
318: FROM gms_award_distributions adl,
319: po_distributions_all po ,

Line 333: FROM DUAL

329: AND nvl(cancel_flag,'N') <> 'Y');
330:
331: CURSOR ap_items_csr IS
332: SELECT 1
333: FROM DUAL
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM gms_award_distributions adl,
337: ap_invoice_distributions_all ap ,

Line 348: FROM DUAL

344: AND AI.CANCELLED_DATE is null);
345:
346: CURSOR req_items_csr IS
347: SELECT 1
348: FROM DUAL
349: WHERE EXISTS
350: (SELECT 'X'
351: FROM gms_award_distributions adl,
352: po_req_distributions_all req ,

Line 564: FROM DUAL

560: /* Bug# 4138033, apart from adding the task id condition, removed the joing with pa_task
561: as the project_id is available on expenditure items itself */
562: CURSOR exp_items_csr IS
563: SELECT 1
564: FROM DUAL
565: WHERE EXISTS
566: (SELECT 'X'
567: FROM pa_expenditure_items_all exp
568: /* pa_tasks tsk 4138033 */

Line 576: FROM DUAL

572: AND exp.expenditure_item_date < P_START_DATE) ;
573:
574: CURSOR enc_items_csr IS
575: SELECT 1
576: FROM DUAL
577: WHERE EXISTS
578: (SELECT 'X'
579: FROM gms_encumbrance_items_all enc,
580: pa_tasks tsk

Line 600: FROM DUAL

596: -- = Allow to change before fully liquidated encumbrances.
597: -- = ============================================================
598: /* CURSOR enc_items_csr2 IS
599: SELECT 1
600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'X'
603: FROM gms_encumbrance_items_all enc1,
604: gms_encumbrance_items_all enc2,

Line 619: FROM DUAL

615: --commented for bug6888744 and modified as below:
616:
617: CURSOR enc_items_csr2 IS
618: SELECT 1
619: FROM DUAL
620: WHERE EXISTS
621: (SELECT 'X'
622: FROM gms_encumbrance_items_all enc1,
623: -- gms_encumbrance_items_all enc2,

Line 637: FROM DUAL

633: AND enc1.encumbrance_item_date < P_START_DATE );
634:
635: CURSOR po_items_csr IS
636: SELECT 1
637: FROM DUAL
638: WHERE EXISTS
639: (SELECT 'X'
640: FROM po_distributions_all po ,
641: po_lines_all pol --Bug 8431879

Line 652: FROM DUAL

648: --Bug 3985177 : Removed pa_tasks join in po_items_csr
649:
650: CURSOR ap_items_csr IS
651: SELECT 1
652: FROM DUAL
653: WHERE EXISTS
654: (SELECT 'X'
655: FROM ap_invoice_distributions_all ap,
656: ap_invoices_all ai --Bug 8431879

Line 667: FROM DUAL

663: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
664:
665: CURSOR req_items_csr IS
666: SELECT 1
667: FROM DUAL
668: WHERE EXISTS
669: (SELECT 'X'
670: FROM po_req_distributions_all req,
671: po_requisition_lines_all pol --Bug 8431879

Line 682: FROM DUAL

678: --Bug 3985177 : Removed pa_tasks join in req_items_csr
679:
680: CURSOR budget_lines_exist_csr IS
681: SELECT 1
682: FROM DUAL
683: WHERE EXISTS
684: ( SELECT 1
685: FROM gms_budget_versions pbv,
686: gms_resource_assignments pra,

Line 696: FROM DUAL

692:
693:
694: CURSOR txn_exists_csr IS
695: SELECT 1
696: FROM DUAL
697: WHERE EXISTS
698: (SELECT 1
699: FROM gms_award_distributions adl
700: WHERE adl.project_id = P_PROJECT_ID

Line 846: FROM DUAL

842: AND pbl.burdened_cost IS NOT null; /*Code change for bug 5470902 */
843:
844: CURSOR exp_items_csr IS
845: SELECT 1
846: FROM DUAL
847: WHERE EXISTS
848: (SELECT 'X'
849: FROM pa_expenditure_items_all exp
850: /* pa_tasks tsk */

Line 858: FROM DUAL

854: AND exp.expenditure_item_date > P_COMPLETION_DATE) ;
855:
856: CURSOR enc_items_csr IS
857: SELECT 1
858: FROM DUAL
859: WHERE EXISTS
860: (SELECT 'X'
861: FROM gms_encumbrance_items_all enc,
862: pa_tasks tsk

Line 881: FROM DUAL

877: -- = Allow to change before fully liquidated encumbrances.
878: -- = ============================================================
879: /* CURSOR enc_items_csr2 IS
880: SELECT 1
881: FROM DUAL
882: WHERE EXISTS
883: (SELECT 'X'
884: FROM gms_encumbrance_items_all enc1,
885: gms_encumbrance_items_all enc2,

Line 902: FROM DUAL

898: --commented for bug6888744 and modified as below:
899:
900: CURSOR enc_items_csr2 IS
901: SELECT 1
902: FROM DUAL
903: WHERE EXISTS
904: (SELECT 'X'
905: FROM gms_encumbrance_items_all enc1,
906: -- gms_encumbrance_items_all enc2,

Line 920: FROM DUAL

916: AND enc1.encumbrance_item_date >P_COMPLETION_DATE ) ;
917:
918: CURSOR po_items_csr IS
919: SELECT 1
920: FROM DUAL
921: WHERE EXISTS
922: (SELECT 'X'
923: FROM po_distributions_all po,
924: po_lines_all pol --Bug 8431879

Line 935: FROM DUAL

931: --Bug 3985177 : Removed pa_tasks join in po_items_csr
932:
933: CURSOR ap_items_csr IS
934: SELECT 1
935: FROM DUAL
936: WHERE EXISTS
937: (SELECT 'X'
938: FROM ap_invoice_distributions_all ap,
939: ap_invoices_all ai --Bug 8431879

Line 951: FROM DUAL

947: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
948:
949: CURSOR req_items_csr IS
950: SELECT 1
951: FROM DUAL
952: WHERE EXISTS
953: (SELECT 'X'
954: FROM po_req_distributions_all req,
955: po_requisition_lines_all pol --Bug 8431879