APPS.JAI_PO_HOOK_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1738: from ap_invoice_lines_all

1734:
1735: IF p_document_type = 'PO_INVOICE_ALL' THEN
1736:
1737: FOR rec in (select distinct invoice_id
1738: from ap_invoice_lines_all
1739: where po_line_location_id IN (select line_Location_id
1740: from po_line_locations_all
1741: where po_header_id=p_header_id)
1742: AND (po_release_id = p_release_id or p_release_id is null)

Line 1762: FOR rec in (select distinct invoice_id from ap_invoice_lines_all where po_line_location_id = p_line_id)

1758: END IF;
1759:
1760: IF p_document_type = 'PO_INVOICE' THEN
1761:
1762: FOR rec in (select distinct invoice_id from ap_invoice_lines_all where po_line_location_id = p_line_id)
1763: LOOP
1764: ln_tax_amt := ln_tax_amt + gettax('INVOICE', rec.invoice_id,null);
1765: END LOOP;
1766: RETURN (ln_tax_amt);