APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_BATCHES

Line 38: ap_batches_all AB,

34: VS.invoice_amount_limit,
35: SP.base_currency_code,
36: nvl(VS.hold_future_payments_flag,'N')
37: from ap_invoices_all AI,
38: ap_batches_all AB,
39: ap_system_parameters_all SP,
40: po_vendor_sites VS
41: where AI.invoice_id = X_invoice_id
42: and AI.batch_id = AB.batch_id (+)

Line 188: l_batch_hold_lookup_code AP_BATCHES.hold_lookup_code%TYPE;

184: l_payment_currency_code
185: AP_INVOICES.payment_currency_code%TYPE;
186: l_invoice_type_lookup_code
187: AP_INVOICES.invoice_type_lookup_code%TYPE;
188: l_batch_hold_lookup_code AP_BATCHES.hold_lookup_code%TYPE;
189: l_batch_hold_reason AP_BATCHES.hold_reason%TYPE;
190: l_vendor_id NUMBER;
191: l_vendor_site_id NUMBER;
192: l_invoice_date AP_INVOICES.invoice_date%TYPE;

Line 189: l_batch_hold_reason AP_BATCHES.hold_reason%TYPE;

185: AP_INVOICES.payment_currency_code%TYPE;
186: l_invoice_type_lookup_code
187: AP_INVOICES.invoice_type_lookup_code%TYPE;
188: l_batch_hold_lookup_code AP_BATCHES.hold_lookup_code%TYPE;
189: l_batch_hold_reason AP_BATCHES.hold_reason%TYPE;
190: l_vendor_id NUMBER;
191: l_vendor_site_id NUMBER;
192: l_invoice_date AP_INVOICES.invoice_date%TYPE;
193: l_error_code VARCHAR2(30);

Line 220: ap_batches AB

216: AB.hold_lookup_code,
217: AB.hold_reason,
218: AI.invoice_date
219: from ap_invoices AI,
220: ap_batches AB
221: where AI.invoice_id = X_invoice_id
222: and AI.batch_id = AB.batch_id (+);
223:
224: BEGIN

Line 745: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(

741: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
742: AI.INVOICE_ID),
743: decode(AB.BATCH_ID,
744: '',null,
745: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(
746: AB.BATCH_ID)),
747: decode(AB.BATCH_ID,
748: '',null,
749: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(

Line 749: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(

745: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(
746: AB.BATCH_ID)),
747: decode(AB.BATCH_ID,
748: '',null,
749: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
750: AB.BATCH_ID))
751: from ap_invoices AI,
752: ap_batches_all AB --Bug: 6668692 : Added _all to table name
753: where AI.invoice_id = X_invoice_id

Line 752: ap_batches_all AB --Bug: 6668692 : Added _all to table name

748: '',null,
749: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
750: AB.BATCH_ID))
751: from ap_invoices AI,
752: ap_batches_all AB --Bug: 6668692 : Added _all to table name
753: where AI.invoice_id = X_invoice_id
754: and AI.batch_id = AB.batch_id (+);
755: BEGIN
756: