APPS.AP_UPDATE_1099_AWT_DISTS_PKG dependencies on AP_INVOICES

Line 24: ap_invoices AI

20: --
21: SELECT SUBSTR(state, 1, 10)
22: INTO l_state
23: FROM po_vendor_sites PVS,
24: ap_invoices AI
25: WHERE AI.invoice_id = P_invoice_id
26: AND PVS.vendor_site_id = AI.vendor_site_id;
27: --
28: return (l_state);

Line 126: ap_invoices AI,

122: SELECT NVL(MIN(invoice_distribution_id),0),
123: NVL(MAX(invoice_distribution_id),0)
124: INTO l_min_invoice_distribution_id, l_max_invoice_distribution_id
125: FROM ap_invoice_distributions ID,
126: ap_invoices AI,
127: po_vendor_sites PVS,
128: po_vendors PV
129: WHERE ID.invoice_id = AI.invoice_id
130: AND AI.vendor_site_id = PVS.vendor_site_id

Line 144: FROM Ap_Invoices AI

140: BETWEEN l_start_date AND sysdate
141: )
142: OR
143: ID.invoice_id IN (SELECT AI.invoice_id
144: FROM Ap_Invoices AI
145: WHERE ID.invoice_id = AI.invoice_id
146: AND NVL(AI.PAYMENT_STATUS_FLAG, 'N') <> 'Y'
147: )
148: );

Line 176: FROM ap_invoices AI,

172: ID.program_id = l_program_id,
173: ID.request_id = l_request_id
174: WHERE ID.invoice_id IN (
175: SELECT AI.invoice_id
176: FROM ap_invoices AI,
177: po_vendors PV,
178: po_vendor_sites PVS
179: WHERE AI.vendor_id = PV.vendor_id
180: AND AI.vendor_site_id = PVS.vendor_site_id

Line 193: FROM Ap_Invoices AI

189: BETWEEN l_start_date AND sysdate
190: )
191: OR
192: ID.invoice_id IN (SELECT AI.invoice_id
193: FROM Ap_Invoices AI
194: WHERE ID.invoice_id = AI.invoice_id
195: AND NVL(AI.PAYMENT_STATUS_FLAG, 'N') <> 'Y'
196: )
197: )