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 1250: v_currency ce_bank_accounts.currency_code%TYPE;

1246: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1247: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1248: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1249: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1250: v_currency ce_bank_accounts.currency_code%TYPE;
1251: v_amount ar_cash_receipt_history.amount%TYPE;
1252: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1253: v_mod_name varchar2(30);
1254: v_mod_vers varchar2(5);

Line 1265: v_cr_currency ce_bank_accounts.currency_code%TYPE;

1261: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1262: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1263: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1264: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1265: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1266:
1267: --
1268: BEGIN
1269: --

Line 1580: v_currency ce_bank_accounts.currency_code%TYPE;

1576: v_gl_date ar_cash_receipt_history.gl_date%TYPE;
1577: v_ex_date ar_cash_receipt_history.exchange_date%TYPE;
1578: v_ex_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1579: v_ex_rate ar_cash_receipts.exchange_rate%TYPE;
1580: v_currency ce_bank_accounts.currency_code%TYPE;
1581: v_amount ar_cash_receipt_history.amount%TYPE;
1582: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1583: v_mod_name varchar2(30);
1584: v_mod_vers varchar2(5);

Line 1595: v_cr_currency ce_bank_accounts.currency_code%TYPE;

1591: -- 785113: Added to compute new acctd amts based on a different exchange rate.
1592: v_crh_amount ar_cash_receipt_history.amount%TYPE;
1593: v_crh_fac_disc_amt ar_cash_receipt_history.amount%TYPE;
1594: v_ex_rate_old ar_cash_receipts.exchange_rate%TYPE;
1595: v_cr_currency ce_bank_accounts.currency_code%TYPE;
1596:
1597: --
1598: BEGIN
1599: --