DBA Data[Home] [Help]

APPS.HRI_OPL_SUPH_ORGMGR dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 161: FROM hr_org_info_types_by_class oitbc,

157: FROM hr_organization_information hoi
158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL
160: AND EXISTS ( SELECT NULL
161: FROM hr_org_info_types_by_class oitbc,
162: hr_organization_information org_info
163: WHERE org_info.organization_id = hoi.organization_id
164: AND org_info.org_information_context = 'CLASS'
165: AND org_info.org_information2 = 'Y'