821: -- Replaced with following select statement per bug 4537515 (sfiresto)
822: BEGIN
823: SELECT name, chart_of_accounts_id, currency_code
824: INTO l_sob_name, l_coa_id, l_sob_currency
825: FROM gl_ledgers_public_v
826: WHERE ledger_id = l_sob_id;
827: EXCEPTION
828: WHEN others THEN
829: l_err_buff := sqlerrm;
907: -- Replaced with following select statement per bug 4537515 (sfiresto)
908: BEGIN
909: SELECT name, chart_of_accounts_id, currency_code
910: INTO l_sob_name, l_coa_id, l_sob_currency
911: FROM gl_ledgers_public_v
912: WHERE ledger_id = l_sob_id;
913: EXCEPTION
914: WHEN others THEN
915: l_err_buff := sqlerrm;
991: -- Replaced with following select statement per bug 4537515 (sfiresto)
992: BEGIN
993: SELECT name, chart_of_accounts_id, currency_code
994: INTO l_sob_name, l_coa_id, l_sob_currency
995: FROM gl_ledgers_public_v
996: WHERE ledger_id = l_sob_id;
997: EXCEPTION
998: WHEN others THEN
999: l_err_buff := sqlerrm;
1085: -- Replaced with following select statement per bug 4537515 (sfiresto)
1086: BEGIN
1087: SELECT name, chart_of_accounts_id, currency_code
1088: INTO l_sob_name, l_coa_id, l_sob_currency
1089: FROM gl_ledgers_public_v
1090: WHERE ledger_id = l_sob_id;
1091: EXCEPTION
1092: WHEN others THEN
1093: l_err_buff := sqlerrm;
1168: -- Replaced with following select statement per bug 4537515 (sfiresto)
1169: BEGIN
1170: SELECT name, chart_of_accounts_id, currency_code
1171: INTO l_sob_name, l_coa_id, l_sob_currency
1172: FROM gl_ledgers_public_v
1173: WHERE ledger_id = l_sob_id;
1174: EXCEPTION
1175: WHEN others THEN
1176: l_err_buff := sqlerrm;
1250: -- Replaced with following select statement per bug 4537515 (sfiresto)
1251: BEGIN
1252: SELECT name, chart_of_accounts_id, currency_code
1253: INTO l_sob_name, l_coa_id, l_sob_currency
1254: FROM gl_ledgers_public_v
1255: WHERE ledger_id = l_sob_id;
1256: EXCEPTION
1257: WHEN others THEN
1258: l_err_buff := sqlerrm;