[Home] [Help]
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
1455: AND inv.invoice_id = pay.invoice_id
1456: AND oc.claim_id = TO_NUMBER(inv.reference_key1) --//Fix for bug 13557215
1473: , AP_INVOICES_PKG.GET_APPROVAL_STATUS( INV.INVOICE_ID, INV.INVOICE_AMOUNT, INV.PAYMENT_STATUS_FLAG, INV.INVOICE_TYPE_LOOKUP_CODE) --"status_code"
1474: , 'AP_DEBIT' --"payment_method"
1475: , NULL
1476: , inv.invoice_amount
1477: FROM ap_invoices_all inv
1478: , ozf_claims_all oc
1479: WHERE oc.claim_id = cv_claim_id
1480: --AND oc.payment_reference_number = inv.invoice_num --//Fix for Bug 13976621
1481: AND oc.claim_id = TO_NUMBER(inv.reference_key1) --//Fix for bug 13557215
1486:
1487: CURSOR csr_get_inv_number(cv_claim_id IN NUMBER) IS
1488: SELECT inv.invoice_num
1489: FROM ozf_claims_all oc
1490: ,ap_invoices_all inv
1491: WHERE oc.claim_id = TO_NUMBER(inv.reference_key1)
1492: --AND oc.payment_reference_number = inv.invoice_num --//Fix for Bug 13976621
1493: AND oc.claim_id = cv_claim_id;
1494:
4548: -- R12: Document Cancellation
4549: CURSOR csr_inv_status(cv_claim_id IN NUMBER) IS
4550: SELECT invoice_id,
4551: cancelled_date
4552: FROM ap_invoices_all ap,
4553: ozf_claims_all oc
4554: WHERE claim_id = cv_claim_id
4555: --AND invoice_num = oc.payment_reference_number --//Fix for bug 13976621
4556: AND TO_NUMBER(ap.reference_key1) = oc.claim_id --//Fix for bug 13557215
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:
4580: BEGIN