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_all AB --Bug8409056

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

Line 803: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(

799: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
800: AI.INVOICE_ID),
801: decode(AB.BATCH_ID,
802: '',null,
803: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(
804: AB.BATCH_ID)),
805: decode(AB.BATCH_ID,
806: '',null,
807: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(

Line 807: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(

803: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(
804: AB.BATCH_ID)),
805: decode(AB.BATCH_ID,
806: '',null,
807: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
808: AB.BATCH_ID))
809: from ap_invoices AI,
810: ap_batches_all AB --Bug: 6668692 : Added _all to table name
811: where AI.invoice_id = X_invoice_id

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

806: '',null,
807: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
808: AB.BATCH_ID))
809: from ap_invoices AI,
810: ap_batches_all AB --Bug: 6668692 : Added _all to table name
811: where AI.invoice_id = X_invoice_id
812: and AI.batch_id = AB.batch_id (+);
813: BEGIN
814: