DBA Data[Home] [Help]

APPS.BIS_UTILITIES_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 83: from hr_all_organization_units

79: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_id) = FND_API.G_TRUE)
80: THEN
81: select organization_id , name
82: into x_organization_id, x_organization_name
83: from hr_all_organization_units
84: where organization_id = p_organization_id;
85: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_name) = FND_API.G_TRUE THEN
86: select organization_id , name
87: into x_organization_id, x_organization_name

Line 88: from hr_all_organization_units

84: where organization_id = p_organization_id;
85: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_organization_name) = FND_API.G_TRUE THEN
86: select organization_id , name
87: into x_organization_id, x_organization_name
88: from hr_all_organization_units
89: where name = p_organization_name;
90: ELSE
91: null;
92: END IF;