DBA Data[Home] [Help]

APPS.AR_REFUNDS_GRP dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 83: FROM ar_receivable_applications_all ra, ap_invoices_v i

79: INTO l_receivable_application_id,
80: l_cash_receipt_id,
81: l_customer_trx_id,
82: l_org_id
83: FROM ar_receivable_applications_all ra, ap_invoices_v i
84: WHERE ra.application_ref_id = p_invoice_id
85: AND i.invoice_id = p_invoice_id
86: AND TO_NUMBER(i.reference_key1) = ra.receivable_application_id
87: AND ra.application_ref_type = 'AP_REFUND_REQUEST'