DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on HR_ORGANIZATION_INFORMATION

Line 1266: AND exists (SELECT null FROM hr_organization_information hoi

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 ;
1266: AND exists (SELECT null FROM hr_organization_information hoi
1267: WHERE hoi.organization_id = hou.organization_id
1268: AND hoi.org_information_context = 'CLASS'
1269: AND hoi.org_information1 = 'BOM_ECOD'
1270: AND hoi.org_information2 = 'Y');