1902: , l_func_currency
1903: , l_precision
1904: FROM
1905: financials_system_params_all fsp
1906: , gl_sets_of_books glb
1907: , gl_currencies glc
1908: WHERE fsp.set_of_books_id = glb.set_of_books_id
1909: AND glb.currency_code = glc.currency_code
1910: AND NVL(fsp.org_id,-99) = NVL(l_org_id,-99);
2268: l_coa_id
2269: FROM
2270: hr_organization_information hoi
2271: , hr_all_organization_units hou
2272: , gl_sets_of_books gl
2273: WHERE hoi.organization_id = hou.organization_id
2274: AND hoi.org_information1 = TO_CHAR(gl.set_of_books_id)
2275: AND hoi.org_information_context='Accounting Information'
2276: AND hoi.organization_id = p_organization_id;