APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 105: FROM HR_ALL_ORGANIZATION_UNITS

101: IF (p_organization_id IS NOT NULL)
102: THEN
103: SELECT organization_id
104: INTO x_organization_id
105: FROM HR_ALL_ORGANIZATION_UNITS
106: WHERE organization_id = p_organization_id;
107: ELSE
108: SELECT organization_id
109: INTO x_organization_id

Line 110: FROM HR_ALL_ORGANIZATION_UNITS

106: WHERE organization_id = p_organization_id;
107: ELSE
108: SELECT organization_id
109: INTO x_organization_id
110: FROM HR_ALL_ORGANIZATION_UNITS
111: WHERE NAME = p_org_name;
112: END IF;
113: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
114: EXCEPTION