APPS.ENG_VAL_TO_ID dependencies on HR_ORGANIZATION_UNITS

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

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

Line 1261: FROM hr_organization_units hou

1257: -- 11.5.10 onwards because Change Import concurrent pogram is used. Otherwise the query should return all
1258: -- departments
1259: SELECT hou.organization_id
1260: INTO l_id
1261: FROM hr_organization_units hou
1262: -- , org_organization_definitions org_def
1263: WHERE hou.name = p_responsible_org
1264: --AND org_def.business_group_id = hou.business_group_id
1265: --AND org_def.organization_id = p_current_org ;