DBA Data[Home] [Help]

APPS.AR_IREC_APPLY_CREDITS dependencies on HZ_CUST_ACCOUNTS

Line 639: FROM ar_payment_schedules ps, hz_cust_accounts hca, ra_terms rt, ra_customer_trx ct

635: l_cash_receipt_id,
636: l_pay_for_cust_id,
637: --Bug 4062938 - Handling of transactions with no site id
638: decode(l_pay_for_cust_site_id, null, -1,l_pay_for_cust_site_id) as customer_site_use_id
639: FROM ar_payment_schedules ps, hz_cust_accounts hca, ra_terms rt, ra_customer_trx ct
640: WHERE ps.payment_schedule_id = p_payment_schedule_id
641: AND ps.customer_id = hca.cust_account_id
642: AND ps.term_id = rt.term_id(+)
643: AND ps.customer_trx_id = ct.customer_trx_id(+);