DBA Data[Home] [Help]

APPS.ARP_DEDUCTION_COVER dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 770: select receivable_application_id from ar_receivable_applications_all

766:
767: /* Bug 7479983: Cursor is used to identify the applications associated to the claim on the receipt */
768:
769: CURSOR get_app_ids(p_cash_rcpt_id in NUMBER, p_ctx_id in NUMBER) IS
770: select receivable_application_id from ar_receivable_applications_all
771: where cash_receipt_id = p_cash_rcpt_id
772: and applied_customer_trx_id = p_ctx_id
773: and status = 'APP'
774: and reversal_gl_date IS NULL