APPS.ARP_PROCESS_APPLICATION dependencies on CE_BANK_ACCT_USES

Line 3578: /* Reverted the fix introduced by 5571095 for bug 5638732 and replaced ce_bank_acct_uses by ce_bank_acct_uses_ou_v

3574:
3575: -- Populate CC ID columns by selecting from receipt method accounts and
3576: -- payment schedule tables.
3577: -- Release 11.5 VAT changes get discount accounts from activity
3578: /* Reverted the fix introduced by 5571095 for bug 5638732 and replaced ce_bank_acct_uses by ce_bank_acct_uses_ou_v
3579: for performance issue */
3580: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */
3581: --BUG 6660834
3582: IF nvl(p_called_from,'NONE') IN ('AUTORECAPI','AUTORECAPI2') THEN

Line 3580: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */

3576: -- payment schedule tables.
3577: -- Release 11.5 VAT changes get discount accounts from activity
3578: /* Reverted the fix introduced by 5571095 for bug 5638732 and replaced ce_bank_acct_uses by ce_bank_acct_uses_ou_v
3579: for performance issue */
3580: /* Removing the ce_bank_acct_uses table from the select statement for bug 5571095 by gnramasa on 06/10/2006 */
3581: --BUG 6660834
3582: IF nvl(p_called_from,'NONE') IN ('AUTORECAPI','AUTORECAPI2') THEN
3583: ar_autorec_api.populate_cached_data( l_receipt_info_rec );
3584:

Line 3643: , ce_bank_acct_uses_ou ba

3639: , l_org_id
3640: FROM ar_cash_receipts cr
3641: , ar_cash_receipt_history crh
3642: , ar_receipt_methods rm
3643: , ce_bank_acct_uses_ou ba
3644: , ar_receipt_method_accounts rma
3645: , ar_payment_schedules ps
3646: , ar_receivables_trx ed
3647: , ar_receivables_trx uned

Line 5304: , ce_bank_acct_uses ba

5300: FROM ar_payment_schedules ps
5301: , ar_cash_receipts cr
5302: , ar_cash_receipt_history crh
5303: , ar_receipt_methods rm
5304: , ce_bank_acct_uses ba
5305: , ar_receipt_method_accounts rma
5306: WHERE ps.payment_schedule_id = p_receipt_ps_id
5307: AND cr.cash_receipt_id = ps.cash_receipt_id
5308: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5823: ce_bank_acct_uses ba,

5819: FROM ar_payment_schedules ps,
5820: ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: ar_receipt_methods rm,
5823: ce_bank_acct_uses ba,
5824: ar_receipt_method_accounts rma,
5825: ar_receivables_trx rt
5826: WHERE ps.payment_schedule_id = p_receipt_ps_id
5827: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 7166: , ce_bank_acct_uses ba

7162: FROM ar_payment_schedules ps
7163: , ar_cash_receipts cr
7164: , ar_cash_receipt_history crh
7165: , ar_receipt_methods rm
7166: , ce_bank_acct_uses ba
7167: , ar_receipt_method_accounts rma
7168: , ar_receivables_trx rt
7169: WHERE ps.payment_schedule_id = p_receipt_ps_id
7170: AND cr.cash_receipt_id = ps.cash_receipt_id