DBA Data[Home] [Help]

APPS.AR_IREC_APPLY_CREDITS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

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

2100: /*
2101:
2102: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2103: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2104: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2105: where acgt.currency_code = p_currency_code
2106: and acgt.trx_class = 'PMT'
2107: and acgt.payment_schedule_id = arp.payment_schedule_id
2108: and acgt1.currency_code = p_currency_code

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

2112: /* bug#6311033-APPLY CREDIT FAILS WITH YOU HAVE PAID SAME INVOICE TWICE ERROR */
2113:
2114: CURSOR duplicate_application(p_currency_code VARCHAR2) IS
2115: select acgt.payment_schedule_id, arp.applied_payment_schedule_id
2116: from ar_irec_apply_credit_gt acgt,ar_receivable_applications_all arp,ar_irec_apply_credit_gt acgt1
2117: where acgt.currency_code = p_currency_code
2118: and acgt.trx_class = 'PMT'
2119: and acgt.payment_schedule_id = arp.payment_schedule_id
2120: and acgt1.currency_code = p_currency_code