DBA Data[Home] [Help]

APPS.ARP_DEDUCTION_COVER dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 788: select receivable_application_id from ar_receivable_applications_all

784:
785: /* Bug 7479983: Cursor is used to identify the applications associated to the claim on the receipt */
786:
787: CURSOR get_app_ids(p_cash_rcpt_id in NUMBER, p_ctx_id in NUMBER) IS
788: select receivable_application_id from ar_receivable_applications_all
789: where cash_receipt_id = p_cash_rcpt_id
790: and applied_customer_trx_id = p_ctx_id
791: and status = 'APP'
792: and reversal_gl_date IS NULL