1061:
1062: -- Bug 5905190
1063: BEGIN
1064: SELECT SUM(NVL(amount,0)) INTO l_inv_line_amt
1065: FROM ap_invoice_lines
1066: WHERE invoice_id = p_invoice_id
1067: AND line_type_lookup_code NOT IN ('AWT')
1068: AND NVL(invoice_includes_prepay_flag, 'Y') = 'Y';
1069: --AND prepay_tax_parent_id IS NULL;