APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on GMS_AWARD_DISTRIBUTIONS

Line 26: FROM gms_award_distributions adl,

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'

Line 39: FROM gms_award_distributions adl,

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'

Line 65: FROM gms_award_distributions adl1,

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

Line 68: gms_award_distributions adl2

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

Line 93: FROM gms_award_distributions adl,

89: SELECT 1
90: FROM DUAL
91: WHERE EXISTS
92: (SELECT 'X'
93: FROM gms_award_distributions adl,
94: po_distributions_all po ,
95: po_lines_all pol --Bug 7660803/8250302
96: WHERE adl.po_distribution_id = po.po_distribution_id
97: AND adl.adl_status = 'A'

Line 111: FROM gms_award_distributions adl,

107: SELECT 1
108: FROM DUAL
109: WHERE EXISTS
110: (SELECT 'X'
111: FROM gms_award_distributions adl,
112: ap_invoice_distributions_all ap ,
113: ap_invoices_all ai --Bug 7660803/8250302
114: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
115: AND adl.adl_status = 'A'

Line 126: FROM gms_award_distributions adl,

122: SELECT 1
123: FROM DUAL
124: WHERE EXISTS
125: (SELECT 'X'
126: FROM gms_award_distributions adl,
127: po_req_distributions_all req ,
128: po_requisition_lines_all pol --Bug 7660803 / 8250302
129: WHERE adl.distribution_id = req.distribution_id
130: AND adl.adl_status = 'A'

Line 251: FROM gms_award_distributions adl,

247: SELECT 1
248: FROM DUAL
249: WHERE EXISTS
250: (SELECT 'X'
251: FROM gms_award_distributions adl,
252: pa_expenditure_items_all exp
253: WHERE adl.expenditure_item_id = exp.expenditure_item_id
254: AND adl.document_type = 'EXP'
255: AND adl.adl_status = 'A'

Line 264: FROM gms_award_distributions adl,

260: SELECT 1
261: FROM DUAL
262: WHERE EXISTS
263: (SELECT 'X'
264: FROM gms_award_distributions adl,
265: gms_encumbrance_items_all enc
266: WHERE adl.expenditure_item_id = enc.encumbrance_item_id
267: AND adl.document_type = 'ENC'
268: AND adl.adl_status = 'A'

Line 290: FROM gms_award_distributions adl1,

286: SELECT 1
287: FROM DUAL
288: WHERE EXISTS
289: (SELECT 'X'
290: FROM gms_award_distributions adl1,
291: gms_encumbrance_items_all enc1,
292: gms_encumbrance_items_all enc2,
293: gms_award_distributions adl2
294: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id

Line 293: gms_award_distributions adl2

289: (SELECT 'X'
290: FROM gms_award_distributions adl1,
291: gms_encumbrance_items_all enc1,
292: gms_encumbrance_items_all enc2,
293: gms_award_distributions adl2
294: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
295: AND adl1.document_type = 'ENC'
296: AND adl1.adl_status = 'A'
297: AND nvl(adl1.reversed_flag, 'N') = 'N' --Bug 5726575

Line 318: FROM gms_award_distributions adl,

314: SELECT 1
315: FROM DUAL
316: WHERE EXISTS
317: (SELECT 'X'
318: FROM gms_award_distributions adl,
319: po_distributions_all po ,
320: po_lines_all pol --bug 7660803 / 8250302
321: WHERE adl.po_distribution_id = po.po_distribution_id
322: AND adl.adl_status = 'A'

Line 336: FROM gms_award_distributions adl,

332: SELECT 1
333: FROM DUAL
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM gms_award_distributions adl,
337: ap_invoice_distributions_all ap ,
338: ap_invoices_all ai --Bug 7660803 / 8250302
339: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
340: AND adl.adl_status = 'A'

Line 351: FROM gms_award_distributions adl,

347: SELECT 1
348: FROM DUAL
349: WHERE EXISTS
350: (SELECT 'X'
351: FROM gms_award_distributions adl,
352: po_req_distributions_all req ,
353: po_requisition_lines_all pol --Bug 7660803 /8250302
354: WHERE adl.distribution_id = req.distribution_id
355: AND adl.adl_status = 'A'

Line 699: FROM gms_award_distributions adl

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
701: AND adl.task_id = nvl(P_TASK_ID, adl.task_id));
702:
703: