APPS.JAI_PO_HOOK_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1913: from ap_invoice_lines_all

1909:
1910: IF p_document_type = 'PO_INVOICE_ALL' THEN
1911:
1912: FOR rec in (select distinct invoice_id
1913: from ap_invoice_lines_all
1914: where po_line_location_id IN (select line_Location_id
1915: from po_line_locations_all
1916: where po_header_id=p_header_id)
1917: AND (po_release_id = p_release_id or p_release_id is null)

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

1946: END IF;
1947:
1948: IF p_document_type = 'PO_INVOICE' THEN
1949:
1950: FOR rec in (select distinct invoice_id from ap_invoice_lines_all where po_line_location_id = p_line_id)
1951: LOOP
1952: ln_tax_amt := ln_tax_amt + gettax('INVOICE', rec.invoice_id,null);
1953: END LOOP;
1954: RETURN (ln_tax_amt);