APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1450: FROM ap_invoice_payments_all pay

1446: , chk.status_lookup_code --"status_code"
1447: , oc.payment_method -- "payment_method"
1448: , sum(NVL(pay.discount_taken,0))
1449: , inv.invoice_amount
1450: FROM ap_invoice_payments_all pay
1451: , ap_checks_all chk
1452: , ap_invoices_all inv
1453: , ozf_claims_all oc
1454: WHERE pay.check_id = chk.check_id

Line 4575: FROM ap_invoice_payments_all pay

4571: l_tax_included_flag BOOLEAN := FALSE;
4572:
4573: CURSOR csr_paid_amount(cv_invoice_id IN NUMBER) IS
4574: SELECT sum(pay.amount + NVL(pay.discount_taken,0))
4575: FROM ap_invoice_payments_all pay
4576: , ap_invoices_all inv
4577: WHERE inv.invoice_id = pay.invoice_id
4578: AND inv.invoice_id = cv_invoice_id;
4579: