APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on CE_BANK_ACCOUNTS

Line 209: 'ce_bank_accounts cba, ' ||

205: 'hz_customer_profiles cpc, ' ||
206: 'ar_receipt_method_accounts rma, ' ||
207: 'ar_receipt_methods rm, ' ||
208: 'ar_receipt_classes rc, ' ||
209: 'ce_bank_accounts cba, ' ||
210: 'ce_bank_acct_uses ba, ' ||
211: 'hz_cust_accounts c, ' ||
212: 'hz_parties party ' ||
213: 'where ' ||

Line 298: 'ce_bank_accounts cba, ' ||

294: statement := statement || 'from ' ||
295: 'ar_cash_receipts cr, ' ||
296: 'ar_cash_receipt_history crh, ' ||
297: 'ar_receipt_method_accounts rma, ' ||
298: 'ce_bank_accounts cba, ' ||
299: 'ce_bank_acct_uses ba, ' ||
300: 'ar_receipt_methods rm, ' ||
301: 'ar_receipt_classes rc, ' ||
302: 'hz_cust_accounts c, ' ||

Line 389: 'ce_bank_accounts cba, ' ||

385: 'hz_customer_profiles cps, ' ||
386: 'ar_receipt_method_accounts rma, ' ||
387: 'ar_receipt_methods rm, ' ||
388: 'ar_receipt_classes rc, ' ||
389: 'ce_bank_accounts cba, ' ||
390: 'ce_bank_acct_uses ba, ' ||
391: 'hz_cust_accounts c, ' ||
392: 'hz_parties party ' ||
393: 'where cr.cash_receipt_id = crh.cash_receipt_id ' ||

Line 525: v_currency ce_bank_accounts.currency_code%TYPE;

521: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
522: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
523: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
524: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
525: v_currency ce_bank_accounts.currency_code%TYPE;
526: v_amount ar_cash_receipt_history.amount%TYPE;
527: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
528: v_mod_name varchar2(30);
529: v_mod_vers varchar2(5);

Line 540: v_cr_currency ce_bank_accounts.currency_code%TYPE;

536: -- 785113: Added to compute new acctd amts based on a different exchange rate.
537: v_crh_amount ar_cash_receipt_history.amount%TYPE;
538: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
539: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
540: v_cr_currency ce_bank_accounts.currency_code%TYPE;
541:
542: --
543: BEGIN
544: --

Line 1222: v_currency ce_bank_accounts.currency_code%TYPE;

1218: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1219: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1220: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1221: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1222: v_currency ce_bank_accounts.currency_code%TYPE;
1223: v_amount ar_cash_receipt_history.amount%TYPE;
1224: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1225: v_mod_name varchar2(30);
1226: v_mod_vers varchar2(5);

Line 1237: v_cr_currency ce_bank_accounts.currency_code%TYPE;

1233: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1234: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1235: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1236: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1237: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1238:
1239: --
1240: BEGIN
1241: --

Line 1552: v_currency ce_bank_accounts.currency_code%TYPE;

1548: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1549: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1550: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1551: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1552: v_currency ce_bank_accounts.currency_code%TYPE;
1553: v_amount ar_cash_receipt_history.amount%TYPE;
1554: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1555: v_mod_name varchar2(30);
1556: v_mod_vers varchar2(5);

Line 1567: v_cr_currency ce_bank_accounts.currency_code%TYPE;

1563: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1564: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1565: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1566: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1567: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1568:
1569: --
1570: BEGIN
1571: --