DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 124: FROM HR_ALL_ORGANIZATION_UNITS

120: p_organization_id <> FND_API.G_MISS_NUM)
121: THEN
122: SELECT organization_id
123: INTO x_organization_id
124: FROM HR_ALL_ORGANIZATION_UNITS
125: WHERE organization_id = p_organization_id;
126: ELSE
127: SELECT organization_id
128: INTO x_organization_id

Line 129: FROM HR_ALL_ORGANIZATION_UNITS

125: WHERE organization_id = p_organization_id;
126: ELSE
127: SELECT organization_id
128: INTO x_organization_id
129: FROM HR_ALL_ORGANIZATION_UNITS
130: WHERE NAME = p_org_name;
131: END IF;
132: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
133: EXCEPTION