BEGIN
SELECT gsob.currency_code
INTO l_local_currency_code
FROM gl_sets_of_books gsob, hr_operating_units hou
WHERE gsob.set_of_books_id = hou.set_of_books_id
AND hou.organization_id = &p_org_id;--OU ID
END;
4) 在程序中加上帐套和本位币的限制
2. 多帐套实现扩展
1) 得到帐套的SQL语句为：
SELECT * FROM gl_ledgers;
2) 得到法人的SQL语句为：
SELECT * FROM xle_entity_profiles;