[Home] [Help]
22: SELECT 1
23: FROM DUAL
24: WHERE EXISTS
25: (SELECT 'X'
26: FROM gms_award_distributions adl,
27: pa_expenditure_items_all exp
28: WHERE adl.expenditure_item_id = exp.expenditure_item_id
29: AND adl.document_type = 'EXP'
30: AND adl.adl_status = 'A'
35: SELECT 1
36: FROM DUAL
37: WHERE EXISTS
38: (SELECT 'X'
39: FROM gms_award_distributions adl,
40: gms_encumbrance_items_all enc
41: WHERE adl.expenditure_item_id = enc.encumbrance_item_id
42: AND adl.document_type = 'ENC'
43: AND adl.adl_status = 'A'
61: SELECT 1
62: FROM DUAL
63: WHERE EXISTS
64: (SELECT 'X'
65: FROM gms_award_distributions adl1,
66: gms_encumbrance_items_all enc1,
67: gms_encumbrance_items_all enc2,
68: gms_award_distributions adl2
69: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
64: (SELECT 'X'
65: FROM gms_award_distributions adl1,
66: gms_encumbrance_items_all enc1,
67: gms_encumbrance_items_all enc2,
68: gms_award_distributions adl2
69: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
70: AND adl1.document_type = 'ENC'
71: AND adl1.adl_status = 'A'
72: AND nvl(adl1.reversed_flag, 'N') = 'N' --Bug 5726575
89: SELECT 1
90: FROM DUAL
91: WHERE EXISTS
92: (SELECT 'X'
93: FROM gms_award_distributions adl,
94: po_distributions_all po
95: WHERE adl.po_distribution_id = po.po_distribution_id
96: AND adl.adl_status = 'A'
97: AND adl.award_id = P_AWARD_ID
104: SELECT 1
105: FROM DUAL
106: WHERE EXISTS
107: (SELECT 'X'
108: FROM gms_award_distributions adl,
109: ap_invoice_distributions_all ap
110: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
111: AND adl.adl_status = 'A'
112: AND adl.award_id = P_AWARD_ID
116: SELECT 1
117: FROM DUAL
118: WHERE EXISTS
119: (SELECT 'X'
120: FROM gms_award_distributions adl,
121: po_req_distributions_all req
122: WHERE adl.distribution_id = req.distribution_id
123: AND adl.adl_status = 'A'
124: AND adl.award_id = P_AWARD_ID
238: SELECT 1
239: FROM DUAL
240: WHERE EXISTS
241: (SELECT 'X'
242: FROM gms_award_distributions adl,
243: pa_expenditure_items_all exp
244: WHERE adl.expenditure_item_id = exp.expenditure_item_id
245: AND adl.document_type = 'EXP'
246: AND adl.adl_status = 'A'
251: SELECT 1
252: FROM DUAL
253: WHERE EXISTS
254: (SELECT 'X'
255: FROM gms_award_distributions adl,
256: gms_encumbrance_items_all enc
257: WHERE adl.expenditure_item_id = enc.encumbrance_item_id
258: AND adl.document_type = 'ENC'
259: AND adl.adl_status = 'A'
277: SELECT 1
278: FROM DUAL
279: WHERE EXISTS
280: (SELECT 'X'
281: FROM gms_award_distributions adl1,
282: gms_encumbrance_items_all enc1,
283: gms_encumbrance_items_all enc2,
284: gms_award_distributions adl2
285: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
280: (SELECT 'X'
281: FROM gms_award_distributions adl1,
282: gms_encumbrance_items_all enc1,
283: gms_encumbrance_items_all enc2,
284: gms_award_distributions adl2
285: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
286: AND adl1.document_type = 'ENC'
287: AND adl1.adl_status = 'A'
288: AND nvl(adl1.reversed_flag, 'N') = 'N' --Bug 5726575
305: SELECT 1
306: FROM DUAL
307: WHERE EXISTS
308: (SELECT 'X'
309: FROM gms_award_distributions adl,
310: po_distributions_all po
311: WHERE adl.po_distribution_id = po.po_distribution_id
312: AND adl.adl_status = 'A'
313: AND adl.award_id = P_AWARD_ID
320: SELECT 1
321: FROM DUAL
322: WHERE EXISTS
323: (SELECT 'X'
324: FROM gms_award_distributions adl,
325: ap_invoice_distributions_all ap
326: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
327: AND adl.adl_status = 'A'
328: AND adl.award_id = P_AWARD_ID
332: SELECT 1
333: FROM DUAL
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM gms_award_distributions adl,
337: po_req_distributions_all req
338: WHERE adl.distribution_id = req.distribution_id
339: AND adl.adl_status = 'A'
340: AND adl.award_id = P_AWARD_ID
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
655: AND adl.task_id = nvl(P_TASK_ID, adl.task_id));
656:
657: