APPS.PA_FAXFACE dependencies on AP_BATCHES

Line 1412: from ap_invoices API, ap_invoice_distributions APID, ap_batches APB,

1408: x_po_vendor_id, x_po_number,
1409: x_invoice_date, x_invoice_created_by,
1410: x_invoice_updated_by,
1411: x_payables_batch_name
1412: from ap_invoices API, ap_invoice_distributions APID, ap_batches APB,
1413: po_vendors POV, po_headers POH ,po_distributions POD
1414: where API.invoice_id = x_invoice_id
1415: and APID.invoice_distribution_id = x_ap_inv_dist_id
1416: and APID.invoice_id = API.invoice_id

Line 1906: curr_payables_batch_name ap_batches.batch_name%TYPE;

1902: curr_invoice_date ap_invoices.invoice_date%TYPE;
1903: curr_invoice_created_by ap_invoices.created_by%TYPE;
1904: curr_invoice_updated_by ap_invoices.last_updated_by%TYPE;
1905: curr_invoice_id ap_invoices.invoice_id%TYPE;
1906: curr_payables_batch_name ap_batches.batch_name%TYPE;
1907: curr_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
1908: curr_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1909: curr_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
1910: prev_employee_id po_vendors.employee_id%type;

Line 1919: prev_payables_batch_name ap_batches.batch_name%TYPE;

1915: prev_invoice_date ap_invoices.invoice_date%TYPE;
1916: prev_invoice_created_by ap_invoices.created_by%TYPE;
1917: prev_invoice_updated_by ap_invoices.last_updated_by%TYPE;
1918: prev_invoice_id ap_invoices.invoice_id%TYPE;
1919: prev_payables_batch_name ap_batches.batch_name%TYPE;
1920: prev_ap_dist_line_number ap_invoice_distributions.distribution_line_number%TYPE;
1921: prev_ap_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1922: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
1923: