APPS.AR_IREC_APPLY_CREDITS dependencies on RA_CUSTOMER_TRX

Line 473: from ar_payment_schedules ps, ra_customer_trx ct

469:
470:
471: select class, amount_due_remaining, cash_receipt_id, ct.PAYING_CUSTOMER_ID, ct.PAYING_SITE_USE_ID, ps.CUSTOMER_ID, ps.CUSTOMER_SITE_USE_ID
472: into l_trx_class, l_amount_due_remaining, l_cash_receipt_id, l_pay_for_cust_id, l_pay_for_cust_site_id, l_customer_id, l_customer_site_use_id
473: from ar_payment_schedules ps, ra_customer_trx ct
474: where ps.CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID(+)
475: and ps.payment_schedule_id = p_payment_schedule_id;
476:
477: --Bug 4000279 - Modified to check for 'UNAPP' status only

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(+);