APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1200: FROM ap_invoice_payments_all pay

1196: , chk.status_lookup_code --"status_code"
1197: , oc.payment_method -- "payment_method"
1198: , sum(NVL(pay.discount_taken,0))
1199: , inv.invoice_amount
1200: FROM ap_invoice_payments_all pay
1201: , ap_checks_all chk
1202: , ap_invoices_all inv
1203: , ozf_claims_all oc
1204: WHERE pay.check_id = chk.check_id

Line 4088: FROM ap_invoice_payments_all pay

4084: l_tax_included_flag BOOLEAN := FALSE;
4085:
4086: CURSOR csr_paid_amount(cv_invoice_id IN NUMBER) IS
4087: SELECT sum(pay.amount + NVL(pay.discount_taken,0))
4088: FROM ap_invoice_payments_all pay
4089: , ap_invoices_all inv
4090: WHERE inv.invoice_id = pay.invoice_id
4091: AND inv.invoice_id = cv_invoice_id;
4092: