APPS.CE_BAT_API dependencies on GL_LEDGERS

Line 847: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;

843: l_cashflow_id1 NUMBER;
844: l_cashflow_id2 NUMBER;
845: l_source_ledger_id NUMBER := NULL;
846: l_destination_ledger_id NUMBER := NULL;
847: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
848: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
849: l_from_ledger_id NUMBER;
850: l_to_ledger_id NUMBER;
851: l_from_bsv VARCHAR2(1000);

Line 848: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;

844: l_cashflow_id2 NUMBER;
845: l_source_ledger_id NUMBER := NULL;
846: l_destination_ledger_id NUMBER := NULL;
847: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
848: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
849: l_from_ledger_id NUMBER;
850: l_to_ledger_id NUMBER;
851: l_from_bsv VARCHAR2(1000);
852: l_to_bsv VARCHAR2(1000);

Line 934: FROM gl_ledgers

930: l_destination_ledger_id := CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
931:
932: SELECT currency_code
933: INTO l_source_ledger_curr
934: FROM gl_ledgers
935: WHERE ledger_id=l_source_ledger_id;
936:
937: SELECT currency_code
938: INTO l_destination_ledger_curr

Line 939: FROM gl_ledgers

935: WHERE ledger_id=l_source_ledger_id;
936:
937: SELECT currency_code
938: INTO l_destination_ledger_curr
939: FROM gl_ledgers
940: WHERE ledger_id=l_destination_ledger_id;
941:
942:
943: -- for bug 6455698

Line 2362: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;

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
2366: l_debug_proc VARCHAR2(30) := 'validate_foreign_currency';

Line 2363: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := 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
2366: l_debug_proc VARCHAR2(30) := 'validate_foreign_currency';
2367: BEGIN

Line 2396: FROM gl_ledgers

2392: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
2393: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
2394: SELECT currency_code
2395: INTO l_source_ledger_curr
2396: FROM gl_ledgers
2397: WHERE ledger_id=l_source_ledger_id;
2398:
2399: SELECT currency_code
2400: INTO l_destination_ledger_curr

Line 2401: FROM gl_ledgers

2397: WHERE ledger_id=l_source_ledger_id;
2398:
2399: SELECT currency_code
2400: INTO l_destination_ledger_curr
2401: FROM gl_ledgers
2402: WHERE ledger_id=l_destination_ledger_id;
2403:
2404: IF p_pmt_currency = l_source_ba_currency_code
2405: THEN