APPS.HR_ORGANIZATION_API dependencies on HR_ORG_INFORMATION_TYPES
Line 2286: hr_org_information_types type
2282: FROM sys.dual
2283: WHERE EXISTS
2284: (SELECT null
2285: FROM hr_org_info_types_by_class class, 2286: hr_org_information_types type 2287: WHERE class.org_classification = p_org_classif_code
2288: AND class.org_information_type = type.org_information_type
2289: AND ( type.legislation_code is null
2290: OR type.legislation_code = l_legislation_code)