APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_INVOICES_ALL

Line 1202: , ap_invoices_all inv

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
1205: AND inv.invoice_id = pay.invoice_id
1206: AND oc.claim_id = cv_claim_id

Line 1226: FROM ap_invoices_all inv

1222: , AP_INVOICES_PKG.GET_APPROVAL_STATUS( INV.INVOICE_ID, INV.INVOICE_AMOUNT, INV.PAYMENT_STATUS_FLAG, INV.INVOICE_TYPE_LOOKUP_CODE) --"status_code"
1223: , 'AP_DEBIT' --"payment_method"
1224: , NULL
1225: , inv.invoice_amount
1226: FROM ap_invoices_all inv
1227: , ozf_claims_all oc
1228: WHERE oc.claim_id = cv_claim_id
1229: AND oc.payment_reference_number = inv.invoice_num
1230: AND oc.vendor_id = inv.vendor_id

Line 4067: FROM ap_invoices_all ap,

4063: -- R12: Document Cancellation
4064: CURSOR csr_inv_status(cv_claim_id IN NUMBER) IS
4065: SELECT invoice_id,
4066: cancelled_date
4067: FROM ap_invoices_all ap,
4068: ozf_claims_all oc
4069: WHERE claim_id = cv_claim_id
4070: AND invoice_num = oc.payment_reference_number
4071: AND ap.vendor_id = oc.vendor_id

Line 4089: , ap_invoices_all inv

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:
4093: BEGIN