DBA Data[Home] [Help]

APPS.ENG_VALIDATE dependencies on HR_ORGANIZATION_UNITS

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

405: RETURN TRUE;
406: END IF;
407: -- Bug 4947849
408: -- The following query has been fixed to fetch valid departments immaterial of the business group in context.
409: -- The view hr_organization_units in iteself is restricted based on the profile HR: Cross Business group
410: -- Value and per_business_group_id in context if the prior value is N.
411: -- Also , it is being assumed here that the user will login to Oracle Appliction for doing an import from
412: -- 11.5.10 onwards because Change Import concurrent pogram is used. Otherwise the query should return all
413: -- departments

Line 416: FROM hr_organization_units hou

412: -- 11.5.10 onwards because Change Import concurrent pogram is used. Otherwise the query should return all
413: -- departments
414: SELECT 'VALID'
415: INTO l_dummy
416: FROM hr_organization_units hou
417: -- ,org_organization_definitions org_def
418: WHERE hou.organization_id = p_responsible_org_id
419: -- AND org_def.organization_id = p_current_org_id
420: -- AND org_def.business_group_id = hou.business_group_id