APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 95: FROM HR_ALL_ORGANIZATION_UNITS

91: IF (p_organization_id IS NOT NULL)
92: THEN
93: SELECT organization_id
94: INTO x_organization_id
95: FROM HR_ALL_ORGANIZATION_UNITS
96: WHERE organization_id = p_organization_id;
97: ELSE
98: SELECT organization_id
99: INTO x_organization_id

Line 100: FROM HR_ALL_ORGANIZATION_UNITS

96: WHERE organization_id = p_organization_id;
97: ELSE
98: SELECT organization_id
99: INTO x_organization_id
100: FROM HR_ALL_ORGANIZATION_UNITS
101: WHERE NAME = p_org_name;
102: END IF;
103: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
104: EXCEPTION