VIEW: APPS.HRI_ORG_LOV_V

Source

View Text - Preformatted

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