DBA Data[Home] [Help]

APPS.OZF_AR_PAYMENT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 2255: FROM ar_receivable_applications_all rec

2251: WHERE claim_id = cv_claim_id;
2252:
2253: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2254: SELECT rec.cash_receipt_id
2255: FROM ar_receivable_applications_all rec
2256: , ar_payment_schedules pay
2257: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2258: AND pay.customer_trx_id = cv_invoice_id;
2259:

Line 2891: FROM ar_receivable_applications_all rec

2887:
2888:
2889: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2890: SELECT rec.cash_receipt_id
2891: FROM ar_receivable_applications_all rec
2892: , ar_payment_schedules pay
2893: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2894: AND pay.customer_trx_id = cv_invoice_id;
2895: