APPS.CE_BAT_API dependencies on GL_LEDGERS

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

691: l_cashflow_id1 NUMBER;
692: l_cashflow_id2 NUMBER;
693: l_source_ledger_id NUMBER := NULL;
694: l_destination_ledger_id NUMBER := NULL;
695: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
696: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
697: l_from_ledger_id NUMBER;
698: l_to_ledger_id NUMBER;
699: l_from_bsv VARCHAR2(1000);

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

692: l_cashflow_id2 NUMBER;
693: l_source_ledger_id NUMBER := NULL;
694: l_destination_ledger_id NUMBER := NULL;
695: l_source_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
696: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := NULL;
697: l_from_ledger_id NUMBER;
698: l_to_ledger_id NUMBER;
699: l_from_bsv VARCHAR2(1000);
700: l_to_bsv VARCHAR2(1000);

Line 768: FROM gl_ledgers

764: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
765: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
766: SELECT currency_code
767: INTO l_source_ledger_curr
768: FROM gl_ledgers
769: WHERE ledger_id=l_source_ledger_id;
770:
771: SELECT currency_code
772: INTO l_destination_ledger_curr

Line 773: FROM gl_ledgers

769: WHERE ledger_id=l_source_ledger_id;
770:
771: SELECT currency_code
772: INTO l_destination_ledger_curr
773: FROM gl_ledgers
774: WHERE ledger_id=l_destination_ledger_id;
775:
776:
777: -- for bug 6455698

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

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
1949: log('>> validate_foreign_currency.....');

Line 1946: l_destination_ledger_curr GL_LEDGERS.currency_code%TYPE := 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
1949: log('>> validate_foreign_currency.....');
1950: p_error_code := NULL;

Line 1976: FROM gl_ledgers

1972: l_source_ledger_id := CE_BAT_UTILS.get_ledger_id(p_source_le_id);
1973: l_destination_ledger_id:=CE_BAT_UTILS.get_ledger_id(p_destination_le_id);
1974: SELECT currency_code
1975: INTO l_source_ledger_curr
1976: FROM gl_ledgers
1977: WHERE ledger_id=l_source_ledger_id;
1978:
1979: SELECT currency_code
1980: INTO l_destination_ledger_curr

Line 1981: FROM gl_ledgers

1977: WHERE ledger_id=l_source_ledger_id;
1978:
1979: SELECT currency_code
1980: INTO l_destination_ledger_curr
1981: FROM gl_ledgers
1982: WHERE ledger_id=l_destination_ledger_id;
1983:
1984: IF p_pmt_currency = l_source_ba_currency_code THEN
1985: IF l_destination_ledger_curr <> l_destination_ba_currency_code THEN