APPS.PA_HR_ORG_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 83: FROM hr_all_organization_units -- Bug 4358448 perf change

79: IF ((p_organization_id <> FND_API.G_MISS_NUM) AND (p_organization_id IS NOT NULL)) THEN
80: IF (p_check_id_flag = 'Y') THEN
81: SELECT organization_id
82: INTO x_organization_id
83: FROM hr_all_organization_units -- Bug 4358448 perf change
84: WHERE organization_id = p_organization_id;
85:
86: ELSIF (p_check_id_flag='N') THEN
87: x_organization_id := p_organization_id;