DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 165: FROM HR_ALL_ORGANIZATION_UNITS

161: p_organization_id <> FND_API.G_MISS_NUM)
162: THEN
163: SELECT organization_id
164: INTO x_organization_id
165: FROM HR_ALL_ORGANIZATION_UNITS
166: WHERE organization_id = p_organization_id;
167: ELSE
168: SELECT organization_id
169: INTO x_organization_id

Line 170: FROM HR_ALL_ORGANIZATION_UNITS

166: WHERE organization_id = p_organization_id;
167: ELSE
168: SELECT organization_id
169: INTO x_organization_id
170: FROM HR_ALL_ORGANIZATION_UNITS
171: WHERE NAME = p_org_name;
172: END IF;
173: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
174: EXCEPTION