DBA Data[Home] [Help]

APPS.OZF_AR_VALIDATION_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 49: FROM ar_receivable_applications rec

45: l_trx_lines csr_claim_line_invoice%ROWTYPE;
46:
47: CURSOR csr_invoice_apply_count(cv_receipt_id IN NUMBER, cv_invoice_id IN NUMBER) IS
48: SELECT COUNT(rec.cash_receipt_id)
49: FROM ar_receivable_applications rec
50: WHERE rec.applied_customer_trx_id = cv_invoice_id
51: AND rec.cash_receipt_id = cv_receipt_id
52: AND rec.display = 'Y';
53: l_apply_receipt_count NUMBER;