DBA Data[Home] [Help]

APPS.AR_IREC_APPLY_CREDITS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 2102: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1

2098: /* bug#6311033-APPLY CREDIT FAILS WITH YOU HAVE PAID SAME INVOICE TWICE ERROR */
2099:
2100: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2101: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2102: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2103: where acgt.currency_code = p_currency_code
2104: and acgt.trx_class = 'PMT'
2105: and acgt.payment_schedule_id = arp.payment_schedule_id
2106: and acgt1.currency_code = p_currency_code