APPS.ENG_VAL_TO_ID dependencies on HR_ORGANIZATION_UNITS

Line 1248: -- The view hr_organization_units in iteself is restricted based on the profile HR: Cross Business group

1244: ret_code NUMBER;
1245: BEGIN
1246: -- Bug 4947857
1247: -- The following query has been fixed to fetch valid departments immaterial of the business group in context.
1248: -- The view hr_organization_units in iteself is restricted based on the profile HR: Cross Business group
1249: -- Value and per_business_group_id in context if the prior value is N.
1250: -- Also , it is being assumed here that the user will login to Oracle Appliction for doing an import from
1251: -- 11.5.10 onwards because Change Import concurrent pogram is used. Otherwise the query should return all
1252: -- departments

Line 1255: FROM hr_organization_units hou

1251: -- 11.5.10 onwards because Change Import concurrent pogram is used. Otherwise the query should return all
1252: -- departments
1253: SELECT hou.organization_id
1254: INTO l_id
1255: FROM hr_organization_units hou
1256: -- , org_organization_definitions org_def
1257: WHERE hou.name = p_responsible_org
1258: --AND org_def.business_group_id = hou.business_group_id
1259: --AND org_def.organization_id = p_current_org ;