SELECT organization_id ,name from hr_organization_units org ,hri_org_param_list opl WHERE opl.org_param_id = HrBisOrgParams.GetOrgParamId and opl.organization_id_child = org.organization_id WITH READ ONLY
View Text - HTML Formatted
SELECT ORGANIZATION_ID , NAME FROM HR_ORGANIZATION_UNITS ORG , HRI_ORG_PARAM_LIST OPL WHERE OPL.ORG_PARAM_ID = HRBISORGPARAMS.GETORGPARAMID AND OPL.ORGANIZATION_ID_CHILD = ORG.ORGANIZATION_ID WITH READ ONLY