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 16: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;

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

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

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

Line 18: G_source_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := NULL;

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

Line 19: G_dest_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE := NULL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 27: G_ba_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE := NULL;

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

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

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

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

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

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

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

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

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

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

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

Line 193: ce_bank_accounts ba,

189: decode(nvl(sp.authorization_bat,'NR'),'NR','N','Y'),
190: sp.legal_entity_id,
191: ba.bank_account_name
192: FROM
193: ce_bank_accounts ba,
194: xle_entity_profiles xfp,
195: hz_party_sites hps,
196: ce_system_parameters sp
197: WHERE

Line 212: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;

208: l_sp_src_le_id NUMBER;
209: l_sp_dest_le_id NUMBER;
210: l_result VARCHAR2(10);
211:
212: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

Line 213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;

209: l_sp_dest_le_id NUMBER;
210: l_result VARCHAR2(10);
211:
212: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

Line 214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;

210: l_result VARCHAR2(10);
211:
212: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

Line 215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;

211:
212: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:

Line 216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

212: l_src_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;

Line 217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

213: l_src_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;

Line 218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

214: l_src_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
215: l_src_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;

Line 220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;

216: l_src_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

Line 221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;

217: l_src_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

Line 222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;

218: l_src_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
226: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

Line 223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;

219:
220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
226: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
227:

Line 224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;

220: l_dest_bank_charge_bearer CE_BANK_ACCOUNTS.pool_bank_charge_bearer_code%TYPE;
221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
226: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
227:
228: --

Line 225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;

221: l_dest_payment_method_code CE_BANK_ACCOUNTS.pool_payment_method_code%TYPE;
222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
226: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
227:
228: --
229: -- Bug 16402102: Added

Line 226: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;

222: l_dest_payment_reason_code CE_BANK_ACCOUNTS.pool_payment_reason_code%TYPE;
223: l_dest_payment_reason_comments CE_BANK_ACCOUNTS.pool_payment_reason_comments%TYPE;
224: l_dest_remittance_message1 CE_BANK_ACCOUNTS.pool_remittance_message1%TYPE;
225: l_dest_remittance_message2 CE_BANK_ACCOUNTS.pool_remittance_message2%TYPE;
226: l_dest_remittance_message3 CE_BANK_ACCOUNTS.pool_remittance_message3%TYPE;
227:
228: --
229: -- Bug 16402102: Added
230: --

Line 876: FROM ce_bank_accounts sba,

872: SELECT sba.bank_account_name,
873: d_ba.bank_account_name
874: INTO g_source_bank_account_name,
875: g_dest_bank_account_name
876: FROM ce_bank_accounts sba,
877: ce_bank_accounts d_ba,
878: ce_payment_transactions pt
879: WHERE pt.trxn_reference_number=p_trxn_reference_number
880: AND sba.bank_account_id=pt.source_bank_account_id

Line 877: ce_bank_accounts d_ba,

873: d_ba.bank_account_name
874: INTO g_source_bank_account_name,
875: g_dest_bank_account_name
876: FROM ce_bank_accounts sba,
877: ce_bank_accounts d_ba,
878: ce_payment_transactions pt
879: WHERE pt.trxn_reference_number=p_trxn_reference_number
880: AND sba.bank_account_id=pt.source_bank_account_id
881: AND d_ba.bank_account_id=pt.destination_bank_account_id;

Line 1892: ce_bank_accounts ba,

1888: l_ext_bankacct_rec.PAYMENT_FACTOR_FLAG,
1889: l_ext_bankacct_rec.foreign_payment_use_flag, -- bug 9088808
1890: l_ext_bankacct_rec.acct_owner_party_id -- bug 11927233
1891: FROM
1892: ce_bank_accounts ba,
1893: ce_bank_branches_v bb
1894: WHERE
1895: ba.bank_branch_id = bb.branch_party_id
1896: AND ba.bank_account_id = p_bank_account_id;

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

2356: )
2357: IS
2358: l_source_ledger_id NUMBER := NULL;
2359: l_destination_ledger_id NUMBER := NULL;
2360: l_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
2361: l_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
2362: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
2363: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
2364:

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

2357: IS
2358: l_source_ledger_id NUMBER := NULL;
2359: l_destination_ledger_id NUMBER := NULL;
2360: l_source_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
2361: l_destination_ba_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE := NULL;
2362: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
2363: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
2364:
2365: -- Bug 16402102: Added

Line 2374: FROM ce_bank_accounts

2370:
2371: -- Get the bank account currencies for source/destination
2372: SELECT currency_code
2373: INTO l_source_ba_currency_code
2374: FROM ce_bank_accounts
2375: WHERE bank_account_id = p_source_ba_id;
2376:
2377: SELECT currency_code
2378: INTO l_destination_ba_currency_code

Line 2379: FROM ce_bank_accounts

2375: WHERE bank_account_id = p_source_ba_id;
2376:
2377: SELECT currency_code
2378: INTO l_destination_ba_currency_code
2379: FROM ce_bank_accounts
2380: WHERE bank_account_id = p_destination_ba_id;
2381:
2382: --Transaction currency is the same as the bank account currency on both sides
2383: --then it is valid bat