813: -- Replaced with following select statement per bug 4537515 (sfiresto)
814: BEGIN
815: SELECT name, chart_of_accounts_id, currency_code
816: INTO l_sob_name, l_coa_id, l_sob_currency
817: FROM gl_ledgers_public_v
818: WHERE ledger_id = l_sob_id;
819: EXCEPTION
820: WHEN others THEN
821: l_err_buff := sqlerrm;
899: -- Replaced with following select statement per bug 4537515 (sfiresto)
900: BEGIN
901: SELECT name, chart_of_accounts_id, currency_code
902: INTO l_sob_name, l_coa_id, l_sob_currency
903: FROM gl_ledgers_public_v
904: WHERE ledger_id = l_sob_id;
905: EXCEPTION
906: WHEN others THEN
907: l_err_buff := sqlerrm;
983: -- Replaced with following select statement per bug 4537515 (sfiresto)
984: BEGIN
985: SELECT name, chart_of_accounts_id, currency_code
986: INTO l_sob_name, l_coa_id, l_sob_currency
987: FROM gl_ledgers_public_v
988: WHERE ledger_id = l_sob_id;
989: EXCEPTION
990: WHEN others THEN
991: l_err_buff := sqlerrm;
1077: -- Replaced with following select statement per bug 4537515 (sfiresto)
1078: BEGIN
1079: SELECT name, chart_of_accounts_id, currency_code
1080: INTO l_sob_name, l_coa_id, l_sob_currency
1081: FROM gl_ledgers_public_v
1082: WHERE ledger_id = l_sob_id;
1083: EXCEPTION
1084: WHEN others THEN
1085: l_err_buff := sqlerrm;
1160: -- Replaced with following select statement per bug 4537515 (sfiresto)
1161: BEGIN
1162: SELECT name, chart_of_accounts_id, currency_code
1163: INTO l_sob_name, l_coa_id, l_sob_currency
1164: FROM gl_ledgers_public_v
1165: WHERE ledger_id = l_sob_id;
1166: EXCEPTION
1167: WHEN others THEN
1168: l_err_buff := sqlerrm;
1242: -- Replaced with following select statement per bug 4537515 (sfiresto)
1243: BEGIN
1244: SELECT name, chart_of_accounts_id, currency_code
1245: INTO l_sob_name, l_coa_id, l_sob_currency
1246: FROM gl_ledgers_public_v
1247: WHERE ledger_id = l_sob_id;
1248: EXCEPTION
1249: WHEN others THEN
1250: l_err_buff := sqlerrm;