DBA Data[Home] [Help]

APPS.PER_VETS_MAG_100A_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 226: hr_all_organization_units hou,

222: upper(replace(replace(hoi2.org_information2,'-',''),',','')) naics, --removed hyphens and commas bug 13905482
223: upper(replace(replace(hoi2.org_information4,'-',''),',','')) duns, --removed hyphens and commas bug 13905482
224: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --removed hyphens and commas bug 13905482
225: from per_gen_hierarchy_nodes pgn,
226: hr_all_organization_units hou,
227: hr_organization_information hoi1,
228: hr_organization_information hoi2,
229: hr_locations_all loc
230: where pgn.hierarchy_version_id = p_hierarchy_version_id