eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_BAT_API dependencies on CE_BANK_ACCOUNTS

Line 18: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;

14: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;
15: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;
16:
17: -- Bank accounts
18: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;

Line 19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;

15: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;
16:
17: -- Bank accounts
18: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;

Line 20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;

16:
17: -- Bank accounts
18: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;

Line 21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;

17: -- Bank accounts
18: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;

Line 22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;

18: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;

Line 23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;

19: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;

Line 24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;

20: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;

Line 25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;

21: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := null;
22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE

Line 26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;

22: G_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;

Line 27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;

23: G_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;
31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;

Line 28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;

24: G_source_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;
31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;
32: G_ba_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE := NULL;

Line 29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE

25: G_destination_ba_asset_ccid CE_BANK_ACCOUNTS.asset_code_combination_id%TYPE := NULL;
26: G_ba_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE := NULL;
27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;
31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;
32: G_ba_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE := NULL;
33: G_ba_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE := NULL;

Line 31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;

27: G_ba_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE := NULL;
28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;
31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;
32: G_ba_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE := NULL;
33: G_ba_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE := NULL;
34:
35:

Line 32: G_ba_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE := NULL;

28: G_ba_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE := NULL;
29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;
31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;
32: G_ba_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE := NULL;
33: G_ba_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE := NULL;
34:
35:
36: -- Legal entity

Line 33: G_ba_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE := NULL;

29: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE
30: := NULL;
31: G_ba_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE := NULL;
32: G_ba_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE := NULL;
33: G_ba_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE := NULL;
34:
35:
36: -- Legal entity
37: G_source_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;

Line 37: G_source_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;

33: G_ba_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE := NULL;
34:
35:
36: -- Legal entity
37: G_source_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
38: G_destination_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
39: G_source_le_party_id XLE_ENTITY_PROFILES.party_id%TYPE := NULL;
40: G_destination_le_party_id XLE_ENTITY_PROFILES.party_id%TYPE := NULL;
41: G_destination_party_site_id HZ_PARTY_SITES.party_site_id%TYPE := NULL;

Line 38: G_destination_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;

34:
35:
36: -- Legal entity
37: G_source_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
38: G_destination_le_id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE := NULL;
39: G_source_le_party_id XLE_ENTITY_PROFILES.party_id%TYPE := NULL;
40: G_destination_le_party_id XLE_ENTITY_PROFILES.party_id%TYPE := NULL;
41: G_destination_party_site_id HZ_PARTY_SITES.party_site_id%TYPE := NULL;
42:

Line 178: ce_bank_accounts ba,

174: 'NR','N','Y'),
175: sp.legal_entity_id,
176: ba.bank_account_name
177: FROM
178: ce_bank_accounts ba,
179: xle_entity_profiles xfp,
180: hz_party_sites hps,
181: ce_system_parameters sp
182: WHERE

Line 191: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;

187: AND hps.party_id(+) = xfp.party_id;
188:
189: l_dummy VARCHAR2(10);
190:
191: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

Line 192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;

188:
189: l_dummy VARCHAR2(10);
190:
191: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

Line 193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;

189: l_dummy VARCHAR2(10);
190:
191: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

Line 194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;

190:
191: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:

Line 195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

191: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;

Line 196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

192: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;

Line 197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

193: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
194: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;

Line 199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;

195: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

Line 200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;

196: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

Line 201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;

197: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
205: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

Line 202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;

198:
199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
205: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
206:

Line 203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

199: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
205: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
206:
207: l_cnt NUMBER;

Line 204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

200: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
205: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
206:
207: l_cnt NUMBER;
208: l_anticipated_float NUMBER;

Line 205: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

201: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
202: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
203: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
204: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
205: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
206:
207: l_cnt NUMBER;
208: l_anticipated_float NUMBER;
209: l_dummy2 NUMBER;

Line 722: FROM ce_bank_accounts sba,

718: SELECT sba.bank_account_name,
719: d_ba.bank_account_name
720: INTO g_source_bank_account_name,
721: g_dest_bank_account_name
722: FROM ce_bank_accounts sba,
723: ce_bank_accounts d_ba,
724: ce_payment_transactions pt
725: WHERE pt.trxn_reference_number=p_trxn_reference_number
726: AND sba.bank_account_id=pt.source_bank_account_id

Line 723: ce_bank_accounts d_ba,

719: d_ba.bank_account_name
720: INTO g_source_bank_account_name,
721: g_dest_bank_account_name
722: FROM ce_bank_accounts sba,
723: ce_bank_accounts d_ba,
724: ce_payment_transactions pt
725: WHERE pt.trxn_reference_number=p_trxn_reference_number
726: AND sba.bank_account_id=pt.source_bank_account_id
727: AND d_ba.bank_account_id=pt.destination_bank_account_id;

Line 1654: ce_bank_accounts ba,

1650: l_ext_bankacct_rec.DESCRIPTION,
1651: l_ext_bankacct_rec.AGENCY_LOCATION_CODE,
1652: l_ext_bankacct_rec.PAYMENT_FACTOR_FLAG
1653: FROM
1654: ce_bank_accounts ba,
1655: ce_bank_branches_v bb
1656: WHERE
1657: ba.bank_branch_id = bb.branch_party_id
1658: AND ba.bank_account_id = p_bank_account_id;

Line 1943: l_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;

1939: )
1940: IS
1941: l_source_ledger_id NUMBER := NULL;
1942: l_destination_ledger_id NUMBER := NULL;
1943: l_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
1944: l_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
1945: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
1946: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
1947:

Line 1944: l_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;

1940: IS
1941: l_source_ledger_id NUMBER := NULL;
1942: l_destination_ledger_id NUMBER := NULL;
1943: l_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
1944: l_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
1945: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
1946: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
1947:
1948: BEGIN

Line 1955: FROM ce_bank_accounts

1951:
1952: -- Get the bank account currencies for source/destination
1953: SELECT currency_code
1954: INTO l_source_ba_currency_code
1955: FROM ce_bank_accounts
1956: WHERE bank_account_id = p_source_ba_id;
1957:
1958: SELECT currency_code
1959: INTO l_destination_ba_currency_code

Line 1960: FROM ce_bank_accounts

1956: WHERE bank_account_id = p_source_ba_id;
1957:
1958: SELECT currency_code
1959: INTO l_destination_ba_currency_code
1960: FROM ce_bank_accounts
1961: WHERE bank_account_id = p_destination_ba_id;
1962:
1963: --Transaction currency is the same as the bank account currency on both sides
1964: --then it is valid bat