APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_INVOICE_PAYMENTS

Line 1045: FROM ap_invoice_payments pay, ap_checks chk

1041: SET payment_status = (SELECT SUBSTRB(lkp.displayed_field,1,30)
1042: FROM ap_lookup_codes lkp
1043: where lkp.lookup_type = 'CHECK STATE'
1044: and lkp.lookup_code IN (select status_lookup_code
1045: FROM ap_invoice_payments pay, ap_checks chk
1046: WHERE pay.check_id = chk.check_id
1047: AND pay.invoice_payment_id = stlmnt_docs.settlement_id)),
1048: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1049: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

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: